Challenging assignment Description:
In this assignment, you will create and modify a PivotTable report and a PivotChart report in order to analyze revenue from the park concessions.
For the purpose of grading the Challenging assignment you are required to perform the following tasks:
Start Excel. Open, save, the downloaded Excel workbook named.
Click cell A2. Insert the Recommend PivotTable, Sum of Amount by Park. Add the Month field to the ROWS area below Park. Place the Item field in the COLUMNS area. Close the PivotTable Fields pane.
Insert a slicer for the Park field and for the Item field. Apply Slicer Style Light 3 to the Park slicer and Slicer Style Light 4 to the Item slicer.
Using the Park and Item slicers, filter the data to show the total revenue for golf fees in Memorial Park.
Change the height of each slicer to 1.5″. Reposition the Park slicer so that the top left corner is located inside the borders of cell E3. Reposition the Item slicer so that the top left corner is located inside the borders of cell E12.
Modify the value field settings in the PivotTable so that values are formatted as numbers with zero decimal places and a 1000 separator.
Make a copy of the Sheet1 worksheet. Rename the copied worksheet Memorial – 3Q Golf Fees. Rename the Sheet1 worksheet Concessions Revenue.
On the Concessions Revenue worksheet, clear all filters and remove the slicers. In cell A1, type Third Quarter Park Concession Revenue.
Display the Field List, and then remove the Month field from the ROWS area to display only the Grand Totals for each park and for each item. Close the PivotTable Fields pane.
From the Concessions Revenue worksheet, insert a PivotChart using the stacked bar chart type. Move the PivotChart to a new worksheet using the name 3Q Concessions Chart.
Change the layout of the PivotChart to Layout 3 and change the chart style to Style 4.
Change the chart title to 3rd Quarter Concession Revenue and ensure that data labels are added to the center of the data points.
Format the Plot Area with the Gradient fill Light Gradient Accent 6 (sixth column, first color). Format the Chart Area with a solid fill using Blue, Accent 1, Lighter 60% (fifth column, third color). Hide all of the field buttons on the chart.
Hide the Park Concessions worksheet.
Save the workbook. Close the workbook and then exit Excel. Submit the workbook for grading.