Spreadsheets I

Tom Kelliher, CS14A

Mar. 21, 1997

Have you e-mailed your PowerPoint project to me?

Introduction

1. What is a spreadsheet?

2. Why would I use one?

Parts of the Excel window:

1. Rows.

2. Columns.

3. Cells.

4. Formula bar.

5. Sheets (Can be renamed).

Cell can contain:

1. Number.

2. Label (text).

3. Formula.

Formulas:

1. Begin with = .

2. Standard arithmetic operations: +, -, *, / .

3. Can contain cell references: =A1+A2+A3+A4 .

4. More convenient: =SUM(A1:A4) .

5. Ranges.

6. Copying formulas.

7. Absolute and relative references.

Excel Exercise