earning American athletes list. The salaries include salary, winnings,
reached an all-ti me high of $26.2 million for 2010, an increase of 11 percent
from 2009. This year's list includes golfers, Nati onal Football League® players,
Nati onal Basketball Associati on® players, Major League Baseball® players,
NASCAR® drivers, and a boxer. But these busy athletes can't do it alone, so they
hire agents to negoti ate their salaries, endorsements, and appearance fees.
The following acti vity illustrates how spreadsheets can be used to compute
the commissions of pro athletes' agents.
2. Type the data as shown.
3. Format the width of column A to 8.0 and center align.
4. Format the width of columns B and C to 18.0 and left align
6. Select cells A7 A8 and use the AutoFill feature to complete the series of
9. Compute the formulas for the TOTAL EARNINGS and AGENT'S COMMISSION for
13. Display formulas in your spreadsheet by using <CTRL> + ` to check for accuracy.
14. Carefully proofread your work for accuracy.
15. Save the spreadsheet as PRO ATHLETES.