The Excel Assignment
- Create a new spreadsheet!
- You’re going to be creating a Golf Score Card!
- You’ll need 4 players and 9 holes. Create your labels for the top of the score card and then create your labels for the rows (players) and the columns (holes)
- Come up with some fictitious scores for your players! Remember that most golf scores are not higher than seven.
- You will need formulas to figure out the sum for each player (each ROW) and the total sum for the hole for the team (column).
- We’ll also figure out the the average number of strokes it took each player. (Figure out the average for each ROW) and the average number of strokes it took your team on each hole (the average for each HOLE)
- Finally, we’re going to assign a money amount for each stroke that the player took. We’ll imagine each stroke cost the player $2.30. You’ll need to set-up a cell below your score card area that contains “2.30″. Then, add a cell for each ROW that contains a formula that multiplies the TOTAL SCORE for the ROW by the cell that contains the “2.30″. You’ll need to use the “$” when you refer to the cell that contains the 2.30 so that Excel doesn’t try to look at a different cell. For example, “$C$6″ – This will refer to the cell C6 and won’t change if you cut and paste it or move it. Don’t forget to format the cells that refer to money as “Currancy” cells so that Excel throws a dollar sign in there!
