61
1. Cut, copy, and
paste data.
2. Use sets of
parentheses in
formulas.
T
his acti vity expands on the L.A. LakersŪ spreadsheet created in Acti vity 4.
This acti vity illustrates how spreadsheets can be used to record:
1. The players, their uniform number, their positi on, and games played.
2. Field goals made, att empted, and percentage.
3. Three-point shots made, att empted, and percentage.
4. Free throws made, att empted, and percentage.
5. Total points scored and scoring average.
L.A. LakersŪ 2
27
1. Open the fi le L.A. LAKERS previously created in Acti vity 4.
Unless otherwise stated, the font should be 10 point Arial.
2. Change the Acti vity # in row 1 to read Acti vity 27.
3. Type the additi onal data as shown in columns E O.
4. Copy cell A2 to cells E2 and K2.
5. Cut cell A4 and paste it in to cell E4.
6. Bold cells E9 O9.
7. Format the width of columns D O to 7.0.
8. Select cells E9 O22 and right align.
9. Format column O as numbers displaying 1 decimal place.
10. Format columns G, J, and M as percentages displaying 1 decimal place.
11. Compute the formulas for the fi rst player as follows (See
Table 27-1
to interpret
the abbreviati ons used in each column):
a. PCT (Percentage of fi eld goals made)=FGM/FGA > In cell G10, type
=E10/F10
b. PCT (Percentage of three-point shots made)=3PM/3PA > In cell J10, type
=H10/I10
c. PCT (Percentage of free throws made)=FTM/FTA > In cell M10, type
=K10/L10
d. PTS (Total points scored)=(FGM*2)+(3PM*3)+FTM > In cell N10, type
=(E10*2)+(H10*3)+K10
e. AVG (Average points per game)=PTS/GAMES PLAYED > In cell O10, type
=N10/D10
12. Use the AutoFill feature to copy the formulas down for the remaining players.
NEW SKILL
NEW SKILL
NEW SKILL
ACTIVITY
For Evaluation Purposes Only