$7$ Apply subtotals to the Coach Stipend Column at each change in Group. AutoFit columns C:D and then collapse the outline so that the Level $2$ summary information is displayed. AutoFit columns C and D$.$

$8$ On the Hilltop$-$Lower County$-$East worksheet, in cell $J1,$ insert a link to the downloaded e$05\_$Director$\_$Information.xIsx workbook. Display the ScreenTip Click here for contact information

$9$ Select all three worksheets. Insert a footer in the left section that includes the file name, and in the right section, insert the Sheet Name. Set the Width and Height to $1$ page, and Center the worksheets horizontally.

$10$ With all worksheets still selected, change the theme to Organic and change the font theme to Candara. If your machine does not have the Organic theme, choose Browse for Themes from the Themes menu and then navigate to your downloaded project files.