20:39 10' Ye $4911 0 Excel_5G_Arts_Programs_Instructions O . . . Grader - Instructions Excel 2019 Project Excel_5G_Arts_Programs Project Description: In this project, you will create a worksheet for the Assistant Director of Arts at Laurel College to analyze the available programs. To complete the project, you will sort and filter data, subtotal and group data, and apply themes to multiple worksheets. Steps to Perform: Points Step Instructions Possible Open the Excel workbook student_Excel_5G_Arts_Programs_as.xisx downloaded with this project 2 Display the Hilltop-Lower County-East worksheet. Select the range A1:J13, and then insert a 12 able. 3 Sort the table on the Campus column using a Custom List. Use the following order: Hilltop, 10 Lower County, and then East. Add a second level sort by Group and a third level sort by Program Name both in ascending order. On the Schedule Comparison worksheet, select the range A2:F3, and then name the range 10 Criteria. Name the range A6:F15 using the name Database, and then name the range A18:F18 using the name Extract. 5 Create an advanced filter that will place in the extract area the records from the Database 12 range in which Spring (enter this value in D3) is their primary schedule and Summer (83) is their secondary schedule. 6 Display the Stipends by Group worksheet. Sort the data in ascending order first by Group and 10 then by Coach Stipend. 7 Apply subtotals to the Coach Stipend Column at each change in Group. AutoFit columns C:D 12 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 10 605_Director_Information.x/sx 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 14 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 10 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. Ungroup the sheets and display the Hilltop-Lower County-East sheet. 11 Save and close the file, and then submit for grading. 0 Total Points 100 Created On: 08/30/2021 GO19_XL_CHOS_GRADER_SG_AS - Arts Programs 1.2 O