John P. Crotty
Objectives:
1. To copy a cell.
2. To examine relative cell addresses.
3. To review naming a range.
Directions:
-
1. Let’s find the totals, the maximum and the minimum for Pam’s field goals and foul shots.
Move the cursor to E25.
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.
-
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.
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.
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.
-
3. Let’s create another range, PAMDATALABEL.
Press / to bring up the Main Menu.
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.
