Podcast
Questions and Answers
Which of the following is a way to filter a PivotTable without using the PivotTable Fields pane?
Which of the following is a way to filter a PivotTable without using the PivotTable Fields pane?
- 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)
How does Excel indicate that a PivotTable has filters applied?
How does Excel indicate that a PivotTable has filters applied?
- 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
Why might adding some fields to a PivotTable create unwanted complexity?
Why might adding some fields to a PivotTable create unwanted complexity?
- 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)
Which of the following is a way to filter a PivotTable without using the PivotTable Fields pane?
Which of the following is a way to filter a PivotTable without using the PivotTable Fields pane?
How does Excel indicate that a PivotTable has filters applied?
How does Excel indicate that a PivotTable has filters applied?
What is an example of unwanted complexity that might be created by adding some fields to a PivotTable?
What is an example of unwanted complexity that might be created by adding some fields to a PivotTable?