PivotTable Filter Mastery
6 Questions
1 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

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?

  • 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?

  • 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?

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

How does Excel indicate that a PivotTable has filters applied?

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

What is an example of unwanted complexity that might be created by adding some fields to a PivotTable?

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

More Like This

PivotTable Mastery
3 questions

PivotTable Mastery

AwestruckCarnelian avatar
AwestruckCarnelian
Test Your Excel Skills
6 questions

Test Your Excel Skills

PrettySerpentine avatar
PrettySerpentine
PivotTable Filtering Mastery
3 questions

PivotTable Filtering Mastery

TrustworthyCarnelian avatar
TrustworthyCarnelian
Use Quizgecko on...
Browser
Browser