64
S
tati sti cs play an important role in any sport. They are used in evaluati ng
team performance as well as the performance of individual players.
Football stati sti cs are very simple to understand and compute.
The following acti vity illustrates how spreadsheets can be used to compute
the completi on percentage of NFLŪ quarterbacks during the 2009 season. In
this acti vity, you will be applying cell shading to enhance the appearance of a
spreadsheet.
1. Change cell
shading.
1. Create a NEW spreadsheet.
Unless otherwise stated, the font should be 10 point Arial.
2. Type the data as shown.
3. Bold cell A2 and change the font size to 16 point.
4. Format the width of columns B and C to 20.0 and left align.
5. Center align cells A5 A30 and cells D5 G30.
6. Compute the formula for the fi rst player's PCT (Completi on Percentage) as
follows:
a. PCT(Completi on Percentage)=CMP(Completed Passes/ATT(Att empted
Passes) In cell G7, type
=F7/E7
7. Use the AutoFill feature to copy the formula down for PCT for the remaining
players.
8. Format cells G7 G30 as percentages displaying 1 decimal place.
9. Change the shading for cells A5 G5 to light gray.
10. Bold row 5.
11. Display formulas in your spreadsheet by using <CTRL> + ` to check for accuracy.
12. Carefully proofread your work for accuracy.
13. Save the spreadsheet as QUARTERBACK STATISTICS.
14. Analyze the changes made to the data in the spreadsheet.
15. Set the Print Area to include all cells containing data in the spreadsheet.
16. Print Preview and adjust the Page Setup so that the spreadsheet fi ts on one
page.
17. Print a copy of the spreadsheet if required by your instructor.
28
Quarterback Stati sti cs
NEW SKILL
ACTIVITY
For Evaluation Purposes Only