Microsoft® Office System Step by Step -- 2003 Edition

Chapter 6 Performing Calculations on Data

Creating Formulas to Calculate Values To name a range of cells

1. Select the cells to be included in the range.

2. Click in the Name Box.

3. Type the name of the range, and press .

Finding and Correcting Errors in Calculations To write a formula

1. Click the cell into which the formula will be written.

2. Type an equal sign, and then type the remainder of the formula.

Finding and Correcting Errors in Calculations To enter a range into a formula

1. Click the cell into which the formula will be written.

2. Type an equal sign, and then type the first part of the formula.

3. Select the cells to be used in the formula.

4. Finish typing the formula. ...