John P. Crotty
Objectives:
-
1. To retrieve a file.
-
2. To create labels as right-aligned, centered or repeating.
-
3. To use non-alphabetic characters as labels.
-
4. To move the cursor with the GOTO key [F5].
Directions:
-
1. Let’s bring back the work you’ve already done.
Steps to retrieve a file:.
Press / to bring up the Main Menu.
Press the right-arrow key 4 times to highlight File.
Press [ENTER] to bring up the File Menu.
Retrieve is the highlighted choice; press [ENTER]
Press the right-arrow or the left-arrow until BASKET is highlighted. Since BASKET is the last file you created, moving left will probably be faster.
-
2. Move to the following cell and create a centered label. Start the entry with a ”, the label-prefix for centered.
-
3. At each of the following cells create right-aligned labels. Start each entry with a “, the label-prefix for right-aligned.
|
CELL
|
LABEL
|
|
C5
|
Field
|
|
C6
|
Goals
|
|
D5
|
Foul
|
|
D6
|
Shots
|
|
E5
|
Total
|
|
E6
|
Points
|
-
4. If a non-alphabetic character is used as the first character in a label, you must begin the entry with a label-prefix. Otherwise, 1-2-3 will beep you. It will think that you have made a mistake in entering a numeric value. Move to each of the following cells and make the entry right-aligned.
|
CELL
|
LABEL
|
|
———
|
———
|
|
C7
|
———
|
|
D7
|
———
|
|
E7
|
———
|
-
5. At each of the following cells create repeating labels. Start each entry with a \,the label-prefix for repeating.
|
CELL
|
LABEL
|
|
C4
|
-
|
|
D4
|
-
|
|
E4
|
-
|
|
A2
|
=
|
|
B2
|
=
|
-
6. Move to the following cell and create a left-aligned label. Start the entry with a ‘, the label-prefix for left-aligned.
|
CELL
|
LABEL
|
|
———
|
———
|
|
A7
|
———
|
-
7. When you have completed entering the labels, resave the file. Use the same filename BASKET.
Steps to resave a file:
Press / to bring up the Main Menu.
Press the right-arrow key 4 times to highlight File.
Press [ENTER] to bring up the File Menu.
Press the right-arrow key 1 time to highlight Save.
Press [ENTER]
1-2-3 now prompts you with BASKET, the file you loaded.
Press [ENTER] to accept 1-2-3’s choice.
Press the right-arrow key 1 time to highlight Replace.
Press [ENTER]
-
8. Now that you are becoming familiar with 1-2-3’s menu structure, I will explain the above keystrokes as:
Press / to bring up the Main Menu.
Select File.
Select Save.
1-2-3 now prompts you with BASKET, the file you loaded.
Press [ENTER] to accept 1-2-3’s choice.
Select Replace.
