background image
68
1. Insert and delete
rows.
T
he Nati onal Basketball Associati onŽ (NBAŽ) is one of the most popular
professional sports leagues in the world! It is esti mated that the American
game is now played by more than 250 million people worldwide in an
organized fashion, as well as by countless others in "pick-up" games.
In the regular season, each NBAŽ team plays 82 games, which are divided
evenly between home and away games. Schedules are not identi cal for all
teams. A team faces opponents in its own division four ti mes a year, teams
from the other two divisions in its conference either three or four ti mes a year,
and teams in the other conference two ti mes each.
The following acti vity illustrates how newspapers use spreadsheets to list the
NBAŽ Standings so sports enthusiasts can see how their favorite teams are
doing as compared to other teams in the NBAŽ.
1. Create a NEW spreadsheet.
Unless otherwise stated, the font should be 10 point Arial.
2. Type the data as shown.
3. Delete rows 5 and 28 simultaneously (Hint: Click and hold <CTRL> to select
both rows).
4. Insert a row above EASTERN CONFERENCE.
5. Format the width of column A to 26.0 and columns B ­ E to 8.0.
6. Bold row 2 and change the font size to 16 point.
7. Bold rows 5 and 27 and change the font size to 14 point.
8. Bold rows 6, 13, 20, 28, 35, and 42 and change the font size to 12 point.
9. Compute the formula for PCT (Percentage Won) for the fi rst game as follows:
a. PCT(Percentage Won)=W/(W+L) (Note: W=Wins, L=Losses) In cell D7, type
=B7/(B7+C7)
b. In cell D7, type
=B7/(B7+C7)
Note: You will compute the GB (Games Back) column in Acti vity 49.
10. Copy and paste the PCT formula in cell D7 for the remaining teams in each
division in column D.
11. Format column D as numbers displaying 3 decimal places.
30
NBAŽ Standings
NEW SKILL
NEW SKILL
ACTIVITY
For Evaluation Purposes Only