GO_e05_Grader_h3.xlsx (solution) Homework | Page 3

and Summer as their secondary season to the range A18: F18.
7 Display the Stipends by Group worksheet. Sort the data
6 in ascending order first by Group and then by Coach Stipend.
8 Subtotal the data on the Stipends by Group worksheet
9 at each change in Group using the Sum function. Add the subtotals to the Coach Stipend column.
9 Collapse the outline so that the Level 2 summary 4 information is displayed, and then autofit columns C: D.
10 Select all three worksheets and modify the page setup
9 so that each worksheet fits on one page and is centered horizontally.