|
|
51
iNPuT
DATA
Pro Athletes
23
16. Analyze the changes made to the data in the spreadsheet.
17. Set the Print Area to include all cells containing data in the spreadsheet.
18. Print Preview and adjust the Page Setup so that the spreadsheet fi ts on one
page. Set the Page Orientati on to Landscape.
19. Print a copy of the spreadsheet if required by your instructor.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
A
B
C
D
E
F
G
Activity 23 Student Name
PRO ATHLETES
2010 Salaries and Agent's Commissions
SALARY/
TOTAL
AGENT'S
RANK ATHLETE
SPORT
WINNINGS
ENDORSEMENTS EARNINGS
COMMISSION
1 Tiger Woods
Golf
20,508,163
70,000,000
2 Phil Mickelson
Golf
9,660,757
52,000,000
Floyd Mayweather, Jr. Boxing
60,000,000
250,000
LeBron James
Basketball
15,779,912
30,000,000
Alex Rodriguez
Baseball
33,000,000
4,000,000
Shaquille O'Neal
Basketball
21,000,000
15,000,000
Kobe Bryant
Basketball
23,034,375
10,000,000
Derek Jeter
Baseball
21,000,000
10,000,000
Peyton Manning
Football
15,800,000
15,000,000
Dwyane Wade
Basketball
15,779,912
12,000,000
Matthew Stafford
Football
26,900,000
750,000
Dwight Howard
Basketball
15,202,590
12,000,000
CC Sabathia
Baseball
26,000,000
500,000
Eli Manning
Football
19,500,000
7,000,000
Kevin Garnett
Basketball
16,417,044
10,000,000
Dale Earnhardt, Jr.
Auto Racing
22,000,000
4,097,190
Philip Rivers
Football
25,600,000
250,000
Tim Duncan
Basketball
22,183,218
3,500,000
Terrell Suggs
Football
24,900,000
75,000
Albert Haynesworth
Football
24,600,000
150,000
Brett Favre
Football
17,000,000
7,000,000
Jermaine O'Neal
Basketball
23,016,000
250,000
Amar'e Stoudemire
Basketball
16,378,325
6,750,000
Tracy McGrady
Basketball
22,483,124
250,000
Carmelo Anthony
Basketball
15,779,912
6,000,000
ACTIVITY
source: http://sportsillustrated.cnn.com/specials/fortunate50-2010/index.html
For Evaluation Purposes Only
|