Excel_5F_Career_Programs - Career Programs - Microsoft Excel - Full answer in 2025

Step Instructions Points Possible
1 Open the Excel workbook Student_Excel_5F_Career_Programs.xlsx downloaded with this project. 0
2 On the Main-East-West worksheet, insert a table using the range A1:J40. Display the Table Styles gallery, and then under Light, in the last row, apply the first style. 10
3 Sort the table by Campus using a Custom List in the following order: MAIN, EAST, WEST. (Mac users, create the custom list in the Excel, Preferences, Custom Lists dialog box.) Add a second level sort by Division and a third level sort by Program Name both in ascending order. 10
4 Display the second worksheet, Delivery Mode Comparison. Copy the range A6:G7, and then Paste the range to cell A1. Change the title in cell A1 to Criteria and then select the range A2:G3 and name it Criteria. 10
5 Copy the range A1:G2, and then Paste the range to cell A36. Change the title in cell A36 to Online-Hybrid Delivery Modes and then select the range A37:G37 and name it Extract Select the range A7:G34, and then name this range Database 15
6 Create an advanced filter that will place in the Extract area the records from the Database range in which Online is the primary delivery mode and Hybrid is the secondary delivery mode.
12
7 Display the Stipends by Division worksheet. Sort the data in ascending order first by Division and then by Program Chair Stipend. 10
8 Apply subtotals to the Program Chair Stipend column at each change in Division. AutoFit columns C: D and then collapse the outline so that the Level 2 summary information is displayed. 20
9 Group all three worksheets. Insert a footer in the left section that includes the file name, and in the right section, insert the Sheet Name. Center the worksheets Horizontally, and then set the Width and Height to 1 page.

9
10 Display the workbook Properties. As the Tags, type career programs and as the Subject, type your course name and section number. 4
11 Save and close the file, and then submit for grading. 0
Total Points 100