Posted: January 31st, 2022

Excel_4E_Concessions

Excel_4E_Concessions

Challenge Description:
Within the following Mastering Excel undertaking, you’ll assist Lindsay Johnson, the Director of Parks and Recreation, create and modify a PivotTable report and PivotChart report to research income from park concessions corresponding to meals, boat leases, and golf charges.

Steps to Carry out:
Step Directions Factors Doable
1 Begin Excel. From the information you downloaded with this undertaking, open the file Student_Excel_4E_Concessions.xlsx. zero
2 Click on cell A2. Insert the final Suggest PivotTable—Sum of Quantity by Park. Add the Month area to the Rows space under Park, and the Merchandise area within the Columns space, after which Shut the PivotTable Fields pane. (Mac customers, make certain that Park shows above Month.) 20
three Insert two slicers, one for the Park area and one for the Merchandise area. Transfer the slicers in order that they’re to the suitable of the PivotTable. Apply Lavender, Slicer Type Mild four to the Park slicer and Mild Orange, Slicer Type Mild 6 to the Merchandise slicer. 10
four Use the slicers to filter the PivotTable by Memorial Park, after which by Golf Charges. Change the Quantity Format to the Quantity class and show zero decimal locations and the 1000 Separator. Transfer the Park slicer in order that its higher left nook aligns with the higher left nook of cell E3. Transfer the Merchandise slicer in order that its higher left nook aligns with the higher left nook of cell H3. 10
5 Make a duplicate of this worksheet and Rename the copied worksheet Memorial Golf Charges Insert a footer with the file identify within the left part. Change the Orientation to Panorama, set the Width to 1 web page, and middle the sheet Horizontally. 10
6 Rename Sheet1 Concessions Income after which clear the filters and take away the slicers. In cell A1, kind Third Quarter Park Concession Income and apply the Title cell model. 14
7 Show the Discipline Checklist, after which take away the Month area from the Rows space to show the Grand totals for every park and for every merchandise. Shut the PivotTable Fields pane. 10
eight Insert a PivotChart utilizing the Stacked Column chart kind. (Mac customers, click on the Design tab, click on Change Chart Sort, level to Column, after which click on Stacked Column.) Transfer the chart to a brand new worksheet named Concessions Chart. eight
9 Apply the Structure three chart structure and Chart Type 5. Because the Chart Title, kind third Quarter Concession Income after which insert a customized footer with the file identify within the left part. Cover the entire area buttons on the chart, if obligatory. 11
10 Cover the Park Concessions worksheet. Show the Concessions Income sheet, after which insert a footer with the file identify within the left part. Change the Orientation to Panorama, set the Width to 1 web page, and middle the sheet Horizontally. 5
11 Show the properties. Because the Tags, kind concession income and because the Topic, kind your course identify and part quantity. 2
12 Save and shut the file, after which submit for grading. zero
Whole Factors 100
———

Excel 4E Concessions

Description of the undertaking:

You’ll help Lindsay Johnson, the Director of Parks and Recreation, in creating and modifying a PivotTable report and a PivotChart report back to assess income from park concessions corresponding to meals, boat leases, and golf charges within the following Mastering Excel undertaking.

Steps to Take:

Factors for Step Directions

1 Open Excel. Open the file Pupil Excel 4E Concessions.xlsx that you simply downloaded with this undertaking.

2

Cell A2 needs to be chosen. Insert the ultimate Suggest PivotTable—Quantity Sum by Park. Shut the PivotTable Fields window after including the Month area to the Rows part under Park and the Merchandise area to the Columns space. (Mac customers, ensure Park is displayed above Month.) 20

three Insert two slicers, one for the Park area and one for the opposite.

Check Price Discount

More Assignment Samples: »

Why choose us

You Want Quality and That’s What We Deliver

Top Essay Writers

To join our team, we choose only the best writers. They each have expertise in specific topic fields and experience in academic writing.

Affordable Prices

We offer student friendly prices while still having maintaining  the best writing standard. Compared to other writing services, our prices are fair and reasonable..

100% Plagiarism-Free

You will never receive a product that contains any plagiarism. We scan every final draft before releasing it to be delivered to a customer.

How it works

When you decide to place an order with Nursing Study Bay, here is what happens:

Complete the Order Form

You will complete our order form, filling in all of the fields and giving us as much instructions detail as possible.

Assignment of Writer

We analyze your order and match it with a custom writer who has the unique qualifications for that subject, and he begins from scratch.

Order in Production and Delivered

You and your writer communicate directly during the process, and, once you receive the final draft, you either approve it or ask for revisions.

Giving us Feedback (and other options)

We want to know how your experience went. You can read other clients’ testimonials too. And among many options, you can choose a favorite writer.

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
We are the "bishops" of academic writing!!Coursework, Essays, Assignments, Research papers and Dissertation Writing Help Services

Get between 15 - 30% Off for Every Order with us, 24/7. Plagiarism-free Papers.