John P. Crotty
Objectives:
-
1. To create formulas using the pointing method.
-
2. To create formulas using the keyboarding method.
Directions:
-
1. Using the pointing method, find Pam’s points for the first 8 games. 1-2-3 likes this method because it minimizes typing mistakes and because it allows you to see the actual cells that you are using.
Move the cursor to E8.
Press + to start the formula.
Press the left-arrow key twice to obtain for our formula the cell which contains the number of baskets scored. The control panel now displays +C8.
Press * to multiply.
Type 2 to multiply by 2 since each basket is worth 2 points.
Press + to add.
Press the left-arrow key once to obtain for our formula the cell which contains the number of foul shots made. The control panel now displays +C8*2+D8.
Press [ENTER] to enter the formula.
Move the cursor to E9 and use the above procedure to find Pam’s points for the Hamden game.
Continue through the West Haven game.
-
2. Using the keyboarding method, find Pam’s points for the next 8 games. You will need to know this method when you are in the Edit Mode.
Move the cursor to E16.
Press + to get into Value Mode.
Type C13*2+D13 to create the formula.
Press [ENTER] or the down-arrow key to enter the formula.
Move the cursor to E17 and use the above procedure to find Pam’s points for the Cross game.
Continue through the remaining games.
-
3. When you have completed entering the formulas, resave the file.
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]
Select Replace.
