Question

Go to the project payments worksheet, which contains a PivotTable showing the estimate and total paid amounts for each client. Add category as the second field in the rows area to include the category of each project in the PivotTable.

a. Drag the "Category" field to the Rows area in the PivotTable.
b. Include "Category" as the first field in the columns area of the PivotTable.
c. Delete the entire project payments worksheet.
d. Add a new worksheet instead of modifying the existing one.

Answer 1

To include project categories in the PivotTable, drag the "Category" field to the Rows area of the existing PivotTable on the project payments worksheet.

Step-by-step explanation:

To include the category of each project in the PivotTable on your project payments worksheet, you should drag the "Category" field to the Rows area in the PivotTable. This action will add the category as a second field, allowing you to see the estimate and total paid amounts for each client, broken down by project category. The correct option here is:

• a. Drag the "Category" field to the Rows area in the PivotTable.

You should not include "Category" as the first field in the columns area, delete the worksheet, or add a new worksheet instead of modifying the existing one for this specific requirement.