John P. Crotty
Objectives:
-
1. To use 1-2-3’s Statistical Functions.
Directions:
-
1. Move to the following cells and create left-aligned labels.
|
CELL
|
LABEL
|
|
A24
|
———
|
|
A25
|
Total
|
|
A27
|
Maximum
|
|
A28
|
Minimum
|
|
A30
|
# of Games
|
-
2. Move to the following cells and create right-aligned labels.
|
CELL
|
LABEL
|
|
C24
|
———
|
|
D24
|
———
|
|
E24
|
———
|
-
3. Using the SUM function, find the total of Pam’s points.
Move the cursor to E25.
Type SUM(
Did you see the (bracket? Quite often I miss it.
Press the up-arrow key 17 times to move the cursor to E8, the first value in the range. Notice how the control panel now says sum(E8
Press . to anchor the range at E8.
Press [END]
Press the down-arrow key. (The range will be highlighted in blue. You do want to sum to the line.)
Type ) to finish the formula.
Press [ENTER] to enter the formula.
The SUM function is probably the most used function. When possible, include an extra row in your SUM range. The extra cell E24 contains a label, a set of hyphens. 1-2-3 gives labels a value of 0. Therefore, including this cell in your range will not affect the value of the SUM function. But, including the cell provides a way to add a new row at the bottom of the column without forcing you to edit the SUM function.
-
4. Using the MAX function, find Pam’s high game.
Move the cursor to E27.
Type MAX(
Press the up-arrow key 19 times to move the cursor to E8, the first value in the range.
Press . to anchor the range at E8.
Press the down-arrow key 16 times to expand the range through E24, the line below the points.
Type ) to finish the formula.
Press [ENTER] to enter the formula.
You may include the extra cell in the MAX range. Hopefully your maximum will be greater than zero.
-
5. Using the MIN function, find Pam’s low game.
Move the cursor to E28.
Type MIN(
Press the up-arrow key 20 times to move the cursor to E8, the first value in the range.
Press . to anchor the range at E8.
Press the down-arrow key 15 times to expand the range through E23, the last value in the range.
Type ) to finish the formula.
Press [ENTER] to enter the formula.
You may not include an extra cell in the MIN range. 1-2-3 will treat the label as a zero point game.
-
6. Using the COUNT function, count the number of games Pam played.
Move the cursor to E30.
Type COUNT(
Move the cursor to E8, the first value in the range.
Press . to anchor the range at E8.
Move the cursor to E23, the last value in the range.
Type ) to finish the formula.
Press [ENTER] to enter the formula.
You may not include an extra cell in the COUNT range. 1-2-3 will treat the label as a zero point game.
-
7. When you have completed entering the formulas, resave the file.
