Sort the values in the Campus , business and finance homework help
We are confident that we have the best essaywriters in the market. We have a team of experienced writers who are familiar with all types of essays, and we are always willing to help you with any questions or problems you might face. Plus, our writers are always available online so you can always get the help you need no matter where you are in the world.
Order a Similar Paper Order a Different Paper
GO! ECH05 H2 – Laurel College – 2.0
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines
Order Paper Now
Project Description:
In this project, you will you will edit a worksheet, with data that has been sorted, filtered, and grouped that analyzes Delivery Modes for programs at Laurel College.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
|
Step |
Instructions |
Points Possible |
|
1 |
Start Excel. Download, save, and open the workbook named GO_e05_Grader_h2.xlsx. |
0.000 |
|
2 |
On the Main-East-West worksheet, insert a table in the range A1:J40. Apply the table style Light 16. |
10.000 |
|
3 |
Sort the values in the Campus column using a custom sort order list. Use the following order: Main, East, and then West. |
8.000 |
|
4 |
Add a second level sort by Division and a third level sort by Program Name, both in ascending order. Convert the table to a range. |
8.000 |
|
5 |
On the Delivery Mode Comparison worksheet, copy the range A6:G7. Paste it in cell A1, and then change the title in cell A1 to Criteria. |
6.000 |
|
6 |
Copy the range A1:G2, paste it in cell A36, and then change the title to Online-Hybrid Delivery Mode. |
6.000 |
|
7 |
Name the range A2:G3 using the name Criteria. Name the range A7:G34 using the name Database, and then name the range A37:G37 using the name Extract. |
8.000 |
|
8 |
In cell E3, type Online and in cell F3, type Hybrid. Create an advanced filter that will copy all records from the Database range with Online as their primary delivery mode and Hybrid as their secondary delivery mode to the range A37:G37. |
10.000 |
|
9 |
Copy the range A36:G37, and then paste it in cell A48. In cell A48 change the word Hybrid to Classroom. In cell F3, change the criteria to Classroom. |
6.000 |
|
10 |
Create an advanced filter that will copy all records from the Database range with Online as their primary delivery mode and Classroom as their secondary delivery mode to the range A49:G49. |
8.000 |
|
11 |
Display the Stipends by Division worksheet. Sort the data in ascending order first by Division and then by Program Chair Stipend. |
6.000 |
|
12 |
Subtotal the data on the Stipends by Division worksheet at each change in Division using the Sum function. Add the subtotals to the Program Chair Stipend column. |
8.000 |
|
13 |
Collapse the outline so that the Level 2 summary information is displayed, and then autofit column D. |
6.000 |
|
14 |
Group all three worksheets and modify the page setup so that each worksheet fits on one page and is centered horizontally. Add the Sheet Name element to the right section of the footer. |
10.000 |
|
15 |
Save the workbook. Ensure that the workbook contains the following sheet tabs, in this order: Main-East-West, Delivery Mode Comparison, and Stipends by Division. Close the workbook, and then exit Excel. Submit the workbook as directed. |
0.000 |
|
Total Points |
100.000 |
Do you have a lot of essay writing to do? Do you feel like you’re struggling to find the right way to go about it? If so, then you might want to consider getting help from a professional essay writer. Click one of the buttons below.
Order a Similar Paper Order a Different Paper
