Premium Only Content
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
-
LIVE
Donald Trump Jr.
1 hour agoAmerican Dominance vs Dems' Delusion | TRIGGERED Ep.287
1,129 watching -
LIVE
Kim Iversen
2 hours agoThe World’s Most “Moral” Army — Kills 40 Kids During "Ceasefire" | Socialism's Coming: The Zohran Mamdani Agenda
8,092 watching -
LIVE
TheCrucible
1 hour agoThe Extravaganza! EP: 63 with Guest Co-Host: Rob Noerr (10/30/25)
4,652 watching -
LIVE
The White House
4 hours agoPresident Trump and the First Lady Participate in Halloween at The White House
1,010 watching -
LIVE
Candace Show Podcast
1 hour agoBREAKING NEWS! The Egyptian Military Was In Provo On 9/10. | Candace Ep 255
7,027 watching -
Redacted News
2 hours agoBREAKING! KASH PATEL'S FBI SHUTS DOWN CHARLIE KIRK ASSASSINATION FOREIGN INTEL PROBE BY JOE KENT
87.4K58 -
LIVE
Dr Disrespect
6 hours ago🔴LIVE - DR DISRESPECT - ARC RAIDERS - SOLO RAIDING THE GALAXY
1,387 watching -
1:12:37
vivafrei
3 hours agoTexas A.G, Sues J&J over Autism Claims! VIva Goes Honeybadger on Liberals! Hasan Piker & MORE!
89.3K33 -
3:19:22
Barry Cunningham
3 hours agoPresident Trump Talks China | Mike Johnson Shutdown Day 30 | Reacting To JD Vance Questions At TPUSA
24.4K6 -
LIVE
LFA TV
20 hours agoLIVE & BREAKING NEWS! | THURSDAY 10/30/25
1,133 watching