7th Grade Google Sheets
- Bold Headings
- Make Heading Font Size 14
- Center Heading Text
- Delete Column C (State)
- Delete Row 1
- Put Borders around all cells with data
- Rename Sheet - Bracket Data
- Use AVG Function to calculate Average Wins
- Use AVG Function to calculate Average Losses
- Use AVG Function to calculate Average Wins for each division
- Make sure all numbers are whole numbers
- Add a tab - rename tab 1 - 2019 March Madness, rename tab 2 Team Rankings
- Copy all of the data from tab 1 onto tab 2
- Sort in order of most wins -> Use Data -> Sort Range -> choose column and descending
- Highlight the teams with the top 5 records
- Graph the scores - top 5 records
Optional:
- Use find and replace to change East to E, West, to W, etc for each region
- on tab 2 use formulas to see the difference in wins each team has from the AVG number of wins (you will need to lock the average wins cell for this)
- do the same for losses (make sure you label columns)
- Concatenate wins/losses columns to make the teams info look like this 12-9 (12 wins, 9 losses)