YOU HAVE TODAY AND NEXT CLASS TO FINISH THIS.
QUIZ
Scenario: You are a manager for the Iowa Hawkeyes. You need to keep track of the following statistics for at least 5 members of the team:
- rebounds
- field goal attempts
- field goals made
- free throw attempts
- free throws made
In addition you need to make the following calculations:
- For each player:
- free throw percentage made
- field goal percentage made
- total rebounds
- Include a formula that calculates each player’s money earned–they earn $2.50 for each free throw made.
- For the team:
- total free throws made
- average free throw percentage
- average field goal percentage
Also, please do the following formatting:
- Round all percentages to 1 decimal place
- Merge and center a title over spreadsheet
- Use conditional formatting to highlight players with a percentage greater than 80% & a percentage lower than 70%
- Use special borders, shading, and font colors to set off important aspects of the spreadsheet
- Rotate contents in at least 1 cell
- Format all dollars