**Tom Kelliher, CS 102**

**Dec. 1, 2003**

Web site due in one week. Remember --- send me e-mail when finished.

E-commerce.

- Introduction to spreadsheets.
- Spreadsheet lab.

More on spreadsheets.

- What is a spreadsheet?
- Why would I use one?

Example file for the following: `grades.xls`

.

Parts of the Excel window:

- Rows.
- Columns.
- Cells.
- Formula bar.
- Sheets (Can be renamed).
- Formatting tools.

Cell can contain one of:

- Number.
- Label (text).
- Formula.

Formulas:

- Begin with
`=`. - Standard arithmetic operations:
`+`,`-`,`*`,`/`. - Can contain cell references:
`=A1+A2+A3+A4`

.Can type references in or select.

- More convenient:
`=SUM(A1:A4)`

.Can select a range.

- Ranges.
- Auto Sum shortcut.
- Paste Function shortcut.
- Copying formulas.
- Absolute and relative references.

Tue Nov 25 09:14:39 EST 2003