QuickHelper

(10)

$20/per page/

About QuickHelper

Levels Tought:
Elementary,High School,College,University,PHD

Expertise:
Accounting,Applied Sciences See all
Accounting,Applied Sciences,Business & Finance,Chemistry,Engineering,Health & Medical Hide all
Teaching Since: May 2017
Last Sign in: 356 Weeks Ago
Questions Answered: 20103
Tutorials Posted: 20155

Education

  • MBA, PHD
    Phoniex
    Jul-2007 - Jun-2012

Experience

  • Corportae Manager
    ChevronTexaco Corporation
    Feb-2009 - Nov-2016

Category > Accounting Posted 24 May 2017 My Price 12.00

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

Question description

 

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

 

Attachments:

Answers

QuickHelper
(10)
Status NEW Posted 24 May 2017 11:05 AM My Price 12.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k Y-----------ou -----------for----------- us-----------ing----------- ou-----------r w-----------ebs-----------ite----------- an-----------d a-----------cqu-----------isi-----------tio-----------n o-----------f m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l

Not Rated(0)