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
-
8:05
MattMorseTV
15 hours ago $7.59 earnedSchumer’s SECRET AGENDA just got EXPOSED.
27.2K36 -
16:37
Robbi On The Record
9 hours agoThe Theater of Manufactured Outrage - When Left and Right Dance for the Same Puppet Master
7251 -
14:31
Sponsored By Jesus Podcast
17 hours agoSATAN Knows Scripture Better Than You | Reading the Bible
1.6K1 -
2:50:36
Side Scrollers Podcast
17 hours agoMore Violent Attacks on Speakers + Hollywood DEMANDS “Free Speech” + More | Side Scrollers
9.78K14 -
17:31
GritsGG
13 hours agoDestoying Warzone Duos Lobby w/ Big Bob!
6.51K2 -
1:28:36
The HotSeat
13 hours agoAntifa Unmasked: Keyboard Warriors with No Courage
9.99K12 -
1:53:11
The Michelle Moore Show
16 hours ago'Why Is Gold & Silver Rising, Is Buying Silver A Good Option Right Now, Options of Getting Into The Market, and More' Guest, Dr. Mike Fuljenz: The Michelle Moore Show (Oct 2, 2025)
10.5K2 -
LIVE
Lofi Girl
2 years agoSynthwave Radio 🌌 - beats to chill/game to
200 watching -
15:03:05
blackfox87
17 hours ago🟢 SUBATHON DAY 1 | BO7 BETA | Premium Creator | #DisabledVeteran
75.8K4 -
2:24:09
The Quartering
7 hours agoCandace Owens WAR With TPUSA, Antifa BLOWN N OUT, & Pathetic Demand For Trump Interview
121K63