Excel_4E_Concessions
Challenge Description:
Within the following Mastering Excel undertaking, you’ll Help 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.
