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 .