Sort the values in the Campus , business and finance homework help

GO! ECH05 H2 – Laurel College – 2.0

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 need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.