Excel It! 2nd Edition Page 18

he L.A. Lakers® are the 2009 2010 Nati onal Basketball Associati on®
(NBA®) champions. In an epic game 7 of the 2010 fi nals, the Lakers®

defeated their age-old rival, the Boston Celti cs®, by a score of 83 to 79. The
fi nals went down to the wire. Aft er a tough fi rst three quarters, the Lakers®
rallied to score 30 points in the fourth quarter. Coach Phil Jackson designated
Lakers® forward, Ron Artest, as MVP of the game, with 20 points scored, 2
three-pointers, and fi ve rebounds.
Off the court, The L.A. Lakers® are very acti ve in the Los Angeles community.
The team's Foundati on assists nonprofi t community organizati ons based on
need. It focuses on the use of sports to promote educati on, teamwork, and
self-esteem among Los Angeles area youth.
The following acti vity illustrates how spreadsheets can be used to create a
sports roster that lists the team's players, uniform numbers, positi ons, and the
number of games played.

1. Change column

widths to ensure

cell data fi ts

properly in

columns.

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 20 point.
4. Bold cell A3 and change the font size to 14 point.

5. Bold cells A9 and B8 D9.
6. Format the width of column A to 20.0.

7. Format the width of columns B, C, and D to 10.0 and center align.

8. Carefully proofread your work for accuracy.
9. Save the spreadsheet as L.A. LAKERS.

10. Analyze the changes made to the data in the spreadsheet.

11. Set the Print Area to include all cells containing data in the spreadsheet.

12. Print Preview and adjust the Page Setup so that the spreadsheet fi ts on one

page.

13. Print a copy of the spreadsheet if required by your instructor.

L.A. Lakers®

NEW SKILL

ACTIVITY

For Evaluation Purposes Only