PivotTable Filter Mastery

Hide the PivotTable Fields pane and filter the PivotTable using the Sort & Filter dialog box

Apply a filter to the PivotTable using the PivotTable Fields pane

Copy and paste the PivotTable data into a new worksheet and filter it there

Use the filter arrows on the Row Labels and Column Labels headers within the body of the PivotTable (correct)

By highlighting the filtered cells in the PivotTable with a different color

By placing a filter indicator next to the Column Labels or Row Labels header, as appropriate, and next to the filtered field name in the PivotTable Fields task pane (correct)

By displaying a message box that shows the applied filters

By adding a new column to the PivotTable that shows the applied filters

Because it might make the PivotTable difficult to read

Because it might cause errors in the PivotTable calculations

Because it might cause the PivotTable to crash

Because it might expand the table unnecessarily (correct)

<p>Clicking on the filter arrows on the Row Labels and Column Labels headers within the body of the PivotTable</p> Signup and view all the answers

<p>By placing a filter indicator next to the Column Labels or Row Labels header</p> Signup and view all the answers

<p>Expanding the table unnecessarily</p> Signup and view all the answers