The+Dream+Team+Average+Salary

media type="custom" key="12348270" width="120" height="120"

//In this project, you will create a spreadsheet to find out what the average salary is for the players on your team.//


 * Use Microsoft Excel to calculate the average salary of your team.
 * Use the Internet to research the type of salary players in your particular sport earn each season.
 * Use proper currency style in formatting the dollar amounts on the worksheet.

1. Using Microsoft Excel, open the Team Roster 2. Save the workbook as **Average Salary**. 3. Change the header of the spreasheet to the following text: Average Salary. 4. In cell G1, enter the following column heading: Salary 5. Bold and center align cell G1. 6. In column G, enter a salary for each player using amounts that are relevant to today's salaries in your particular sport. 7. Format column G as currency showing the "$" symbol and two decimal places. 8. Enter a formula at the bottom of the Salary column to find the Average Salary // Use the =AVERAGE formula. // 9. In the cell to the immediate left of the average salary, enter the following text: Average Salary 10. Proofread your work for accuracy. 11. Resave the file. 12. Print a copy of the document.

[|Sample of Average Salary] workbook.

RUBRIC
Continue to Season Schedule