Switch to the editing pivot table worksheet. it contains the editingprojects pivot table, which is based on the editors table on the editing projects worksheet. Display the pivottable firld list, and then remove the average of total projects field from the values area. move the group id field so that it appears as the second field in the rows area to make the pivot table easier to interpret.

New Perspectives Excel 2019 Module 7: End of Module Project 2 5 Switch to the Editing PivotTable worksheet. It contains the Editing Projects PivotTable, which is based on the Editors table on the Editing Projects worksheet. Display the PivotTable Field List, and then remove the Average of Total Projects field from the Values area. Move the GroupID field so that it appears as the second field in the Rows area to make the Pivottable easier to interpret. 6. Alex wants another way to compare the editing projects by level, but not by group. Collapse the outline in the Editing Projects PivotTable to display the Level names and to hide the Group IDs. Insert a PivotChart based on the Editing Projects PivotTable using the Stacked Column chart type. Resize and reposition the PivotChart so that the upper- left corner is located within cell A12 and the lower-right corner is located within cell F25. Change the PivotChart colors to Monochromatic Palette 5 to coordinate with the Pivottable. 7. Alex needs to concentrate on copywriting and internal editing projects. Use the Specialty slicer to filter the PivotTable and PivotChart to display only Copywriting and Internal editing projects. 8. Switch to the Platinum Editing Groups worksheet, which includes the Platinum table listing editing project data for groups at the Platinum level, the highest editing level in the company. Alex wants to display statistics in cells B15 and B17. In cell B15, use the INDEX function to display the value in the first row and first column of the Platinum table. 9. In cell B17, use the SUMIF function and structured references to display the total number of projects completed by groups with the Reviews specialty, 10. Alex wants to compare the Platinum group data for January by specialty, He asks you to create a Pivot Table to better manipulate and filter the data. On a new worksheet create a recommended PivotTable based on the platinum table that shows the Sum of Jan by Specialty. [Mac Hint Insert a new pivottable on a new worksheel, adding the Specialty field to the Rows area and then fold to the values and Use Platinum Pivot Table for the name of the worksheet contalong this Pivorable. Apply Rosa, Pivot Style Medlun 13 to match the style of the other tables in the workbook 11 Alex asks you to customize the neve pivottable to show more details and to provide filter. Add the Total Projects field to tha Values are below the sun of an told the New Perspectives Excel 2019 Module 7: End of Module Project 2 5 Switch to the Editing PivotTable worksheet. It contains the Editing Projects PivotTable, which is based on the Editors table on the Editing Projects worksheet. Display the PivotTable Field List, and then remove the Average of Total Projects field from the Values area. Move the GroupID field so that it appears as the second field in the Rows area to make the Pivottable easier to interpret. 6. Alex wants another way to compare the editing projects by level, but not by group. Collapse the outline in the Editing Projects PivotTable to display the Level names and to hide the Group IDs. Insert a PivotChart based on the Editing Projects PivotTable using the Stacked Column chart type. Resize and reposition the PivotChart so that the upper- left corner is located within cell A12 and the lower-right corner is located within cell F25. Change the PivotChart colors to Monochromatic Palette 5 to coordinate with the Pivottable. 7. Alex needs to concentrate on copywriting and internal editing projects. Use the Specialty slicer to filter the PivotTable and PivotChart to display only Copywriting and Internal editing projects. 8. Switch to the Platinum Editing Groups worksheet, which includes the Platinum table listing editing project data for groups at the Platinum level, the highest editing level in the company. Alex wants to display statistics in cells B15 and B17. In cell B15, use the INDEX function to display the value in the first row and first column of the Platinum table. 9. In cell B17, use the SUMIF function and structured references to display the total number of projects completed by groups with the Reviews specialty, 10. Alex wants to compare the Platinum group data for January by specialty, He asks you to create a Pivot Table to better manipulate and filter the data. On a new worksheet create a recommended PivotTable based on the platinum table that shows the Sum of Jan by Specialty. [Mac Hint Insert a new pivottable on a new worksheel, adding the Specialty field to the Rows area and then fold to the values and Use Platinum Pivot Table for the name of the worksheet contalong this Pivorable. Apply Rosa, Pivot Style Medlun 13 to match the style of the other tables in the workbook 11 Alex asks you to customize the neve pivottable to show more details and to provide filter. Add the Total Projects field to tha Values are below the sun of an told the