Assignment Instructions

Now you want to hide the details for two employees and focus on details for the remaining employees.

Collapse the Davidson and Miller sections to show only their totals. Leave the other emphoyees' individual rows displayed.

$5$

For more detailed analysis, you are ready to create a

$8$

PivotTable.

Use the Expenses worksheet to create a blank PivotTable on a new worksheet named Summary. Use the default report layout for the PivotTable $($Compact Form$).$ Name the PivotTable Categories. When creating the PivotTable, do not select the option to Add this data to the Data Model.

$6$

You want to include the Category and Expense fields in the PivotTable.

Use the Category and Expense fields, enabling Excel to determine where the fields go in the PivotTable.

$7$