# The Measurement of Adolescents, II

## Statistics and Spreadsheets

Your feedback is important to us!

After viewing our curriculum units, please take a few minutes to help us understand how the units, which were created by public school teachers, may be useful to others.

## Lesson 8

### Objectives:

1. To copy a cell.2. To examine relative cell addresses.

3. To review naming a range.

### Directions:

Move the cursor to E25.

- 1. Let’s find the totals, the maximum and the minimum for Pam’s field goals and foul shots.

Press / to bring up the Main Menu.

Select Copy.

Press [ENTER] since we just want to copy the 1 cell.

Press the left-arrow key 1 time to move to the first target.

Press . to anchor the target.

Press the left-arrow key 1 time to move to the last target.

Press [ENTER]

Repeat the above procedure at cells E27 and E28.

The formulas are different because unless you specify otherwise, cell addresses used in formulas are relative. 1-2-3 reads the formula in cell E25 as add the cells that lie in range from 17 rows above me to 1 row above me.

- 2. Let’s compare the formulas in column D and column C to their original formula in column E. Notice that the formulas are not duplicate copies of the formulas in column E. Instead, they adjusted to the columns in which they appear.

1-2-3 copies this relationship to the other 2 columns. Column D and column C use the same relationship. Add the cells that lie in the range from 17 rows above me to 1 row above me.

Press / to bring up the Main Menu.

- 3. Let’s create another range, PAMDATALABEL.

Select Range.

Select Name.

Create is highlighted; press [ENTER]

Type in the name, PAMDATALABEL

Press [ENTER]

Press [BACKSPACE] to remove the anchor.

Move the cursor to G8, the first location.

Press . to anchor G8.

Move the cursor to G23, the last location.

Press [ENTER]

Let’s enter a label in this range.

Move the cursor to G13.

Enter the label POW!

4. Save your work.