Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

Collegiate Seminars Phillip Cunningham is the new manager of Collegiate Seminars in McLean, Virginia. To help him better understand the current schedule, he created an

Collegiate Seminars Phillip Cunningham is the new manager of Collegiate Seminars in McLean, Virginia. To help him better understand the current schedule, he created an Excel table that tracks the data he has collected about currently scheduled seminars, including topic, type, instructor, length, location, cost, and maximum enrollment. He asks you to analyze this data. Complete the following: 1. Open the "Seminars' workbook attached, and save the workbook as "Seminar Bookings" 2. In the Documentation worksheet, enter your name and the date. 3. In the Seminars worksheet, create an Excel table, and then name it Seminars Tbi". Format the Cost column with the Accounting format and no decimal places. Format the SeminarsTbl table with the table style of your choice. 4. Make a copy of the Seminars worksheet, and then rename the copied worksheet as 'Sort by Type". (Hint: Press the Ctrl key, and drag the Seminars sheet tab to the right of the Seminars sheet tab to make a copy of the worksheet.) Sort the SeminarsTbl table in ascending order by Type, then in descending order by Cost. 5. Use conditional formatting to highlight all Seminars with a cost greater than $950 with yellow fill with dark yellow text 6. Make a copy of the Seminars worksheet, and then rename the copied worksheet as "Filter by Location. Insert a slicer to filter by Location. Place the slicer to the right of the top of the SeminarsTbl table. Select a slicer style that matches the style you used to format the SeminarsTbl table Resize the slicer's height and

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions