27
1. Print gridlines in a
spreadsheet.
2. Copy and paste
formulas.
T
he great All-American pasti me is certainly baseball. Most Major League
Baseball (MLB®) games are nati onally televised so that fans can enjoy
watching their favorite teams play. Baseball fans seeking informati on about
the standings of the various teams can obtain that informati on from the
Internet and most daily newspapers.
The following acti vity illustrates how Web sites and newspapers use
spreadsheets to list the MLB® standings.
MLB® Standings
13
1. Create a NEW spreadsheet.
Unless otherwise stated, the font should be set to 10 point Arial.
2. Type the data as shown.
3. Set the top margin to .5 inches and the bott om margin to .25 inches.
4. Bold cell A2 and change the font size to 20 point.
5. Bold cells C4 and C28 and change the font size to 14 point.
6. Bold cells A5, A13, A21, A29, A37, and A46 and change the font size to 12 point.
7. Bold rows 6, 14, 22, 30, 38, and 47.
8. Format the width of column A to 15.0 and columns B G to 8.0.
9. Center align cells B6 G52.
10. Enter the formula to calculate the PCT (Winning Percentage) for the fi rst team,
the NY Yankees®, as follows: PCT=W/(W+L) (Note: W=Wins, L=Losses) -> In cell
D7, type
=B7/(B7+C7)
11. To complete the PCT column for each team, copy and paste the formula in cell
D7 to cells D8 D11, D15 D19, D23 D26, D31 D35, D39 D44, and D48
D52.
12. Select column D and format it as numbers displaying 3 decimal places.
13. Enter the formula to calculate the DIFF (Run Diff erenti al) for the fi rst team, the
NY Yankees®, as follows: DIFF=RS-RA (Note: RS=Runs Scored, RA=Runs Allowed)
-> In cell G7, type
=E7-F7
NEW SKILL
ACTIVITY
For Evaluation Purposes Only