Podcast
Questions and Answers
Which control allows you to hide levels of detail in a PivotTable report?
Which control allows you to hide levels of detail in a PivotTable report?
- The Show Detail control
- The Hide Detail control (correct)
- The Collapse All control
- The Expand All control
What does the Show Detail control look like?
What does the Show Detail control look like?
- A box with a minus sign in it
- A box with a plus sign in it (correct)
- A box with an arrow pointing up
- A box with an arrow pointing down
When would you use the Hide Detail control in a PivotTable report?
When would you use the Hide Detail control in a PivotTable report?
- To sort the data in a different way
- To add more fields to the Rows area
- To change the formatting of the report
- To filter values by hiding levels of detail (correct)
Flashcards are hidden until you start studying