Step Instructions Points Possible From the downloaded project files, open the file GO_e07_Grader_83.x/sx. Save the file as Lastname_Firstname_GO_e07_Grader_a3 in your Excel Chapter 7 folder. 0.000 Click cell A2, and then insert a Recommended PivotTable by choosing the Blank 2 PivotTable option in the lower left corner of the dialog box. Filter by the Month field. Use the Center field as the row labels and the Program field as the column labels. 10.000 Place the Amount field in the Values area. Close the PivotTable Fields list. Format the values in the PivotTable using the Number category to display zero decimal places and the 1000 Separator. 5.000 Insert a slicer for the Program field and for the Center field. Apply Light Turquoise, Slicer Style Dark 4 and Light Yellow, Slicer Style Dark 3 to the slicers, respectively. 10.000 Note, depending on the version of Office used, the style names may be Slicer Style Dark 4 and Slicer Style Dark 3. By using the two slicers, filter the data to show, for the Bard Hall Senior Center, 5 the total revenue for Ceramics and Water Color. Recall that you can select multiple filters in a slicer. Move the two slicers to the right of the filtered PivotTable, and 5.000 then make a copy of this worksheet. Name the copied worksheet Bard Hall - 3Q Display Sheetl. Note, Mac users will need to click Filter Connections on the PicotTable Analyze tab, and clear all the check boxes. 6 3.000 Clear the filters from the slicers and remove the slicers from the worksheet. Rename the sheet 3Q Revenue Insert a PivotChart using the Stacked Column chart type. Note, Mac users will need to select the range A4:E7 and create a traditional Stacked Column. Once the chart 7 is created, on the Chart Design tab, click Switch Row/Column. 4.000 Move the chart to a new worksheet named 3Q Revenue Chart. Apply Chart Style 11 to the chart and then apply the Layout 2 chart layout (in that 8 order). Add centered data labels, and then hide all of the field buttons on the chart. As the Chart Title, type 3rd Quarter Program Revenue and then insert a custom 15.000 footer with the file name in the left