John P. Crotty
Objectives:
1. To name a range.
2. To draw an improved graph.
Directions:
-
1. Let’s list the opponents along the X-axis. Since there is limited room along the axis for names, we’ll use abbreviations. Move to the following cells and enter the labels.
|
CELL
|
LABEL
|
|
B8
|
N
|
|
B9
|
Hm
|
|
B10
|
W
|
|
B11
|
Cb
|
|
B12
|
HH
|
|
B13
|
Hr
|
|
B14
|
C
|
|
B15
|
WH
|
|
B16
|
M
|
|
B17
|
WH
|
|
B18
|
B
|
|
B19
|
VR
|
|
B20
|
Hm
|
|
B21
|
Hd
|
|
B22
|
C
|
|
B23
|
HH
|
-
2. A powerful tool in 1-2-3 is the ability to assign a name to a range of cells. Naming ranges makes your formulas more meaningful and more easily read. The formulas will automatically adjust when the range is moved or changed. And maybe most importantly, you have the ability to access these named ranges from other worksheets.
Let’s name the range of opponents, OPPONENTS.
Move the cursor to B8.
Press / to bring up the Main Menu
Select Range.
Select Name.
Create is highlighted; press [ENTER]
Type in the name, OPPONENTS
Press [ENTER]
The control panel now prompts for the location. Since we’re already on the first cell and since the 2 periods tell us we’re already anchored,
Press [END] to indicate we want to jump.
Press the down-arrow key to show the jump’s direction. (All 16 abbreviations should now be highlighted.)
Press [ENTER]
-
3. Now let’s improve our graph’s appearance.
Press / to bring up the Main Menu.
Select Graph.
Type is highlighted; press [ENTER]
Line is highlighted; press [ENTER]
Select X.
Type OPPONENTS for the range.
Press [ENTER]
Select Options.
Legend is highlighted; press [ENTER]
A is highlighted so press [ENTER]
Type Pam
Press [ENTER]
Select Titles.
First is highlighted so press [ENTER]
Type Basket Busters
Press [ENTER]
Titles is highlighted; press [ENTER].
Select Second.
Type 84 85
Press [ENTER]
Titles is highlighted; press [ENTER].
Select Y-Axis.
Type Points Scored
Press [ENTER]
Select Color
It will seem like nothing has happened, but you have just turned on Color.
-
4. Let’s name this graph. I’ll call mine Pam1. Select Quit to leave the Options Menu.
Select Name.
Select Create.
Type Pam1
Press [ENTER]
5. To view the graphs
Name is highlighted so press [ENTER].
Use is highlighted so press [ENTER].
Highlight whichever graph you wish to see.
Press [ENTER]
Press any key to continue.
-
6. To leave the graph routine and return to the Ready mode.
Select Quit.
7. Again, be sure to save your work.
