The+Dream+Team+Roster

media type="custom" key="12348118" width="130" height="130"

//In this project, you will use a spreadshet to create a team roster with the players you chose for your team.//


 * Use Microsoft Excel to organize your dream team roster
 * Be sure to input all of your records accurately.
 * If information is not available, do your best to estimate this information.

1. Using Microsoft Excel, create a new workbook. 2. Save the workbook as Team Roster 3. Insert a header with the text: **The (//year)// (//team name)// Roster** 4. In cells A1 - F1 enter the following column headings: First Name, Last Name, Position, Height, Weigh, and Uniform #. 5. Bold and center align cells A1 - F1. 6. Complete the spreadsheet with the information froabout your players. Players' height should be entered in the following format: 6'3" or 5'7" 7. Rename the worksheet tab (Sheet 1) to team Roster 8. Resize the columns so that all data displays properly 9. Proofread your work for accuracy 10. Sort the roster by Last Name and then by First Name in ascending order 11. View the roster to make sure the data has been sorted. 12. Print a copy of the sorted document. 13. Next, sort the roster by each player's uniform number in ascending order. 14. View the roster to make sure the data has been sorted. 15. Resave the file 16. Print a copy of the sorted document

[|Sample Roster] Refer to the sample for assistance only. Do not copy the content or design of the sample.

Continue to Average Salary