How Can One Filter a PivotTable Using a Report Filter

question 5

Multiple Choice

How can one filter a PivotTable using a report filter?

• A) Click on the drop down arrow for a Report Filter in the pivot table and Click (All).
• B) Click the Report Filter's drop-down arrow,then click on an item to select an item in the list and click OK.
• C) Right-click a cell in the pivot table,and click Pivot Table Options,then set the 'Display Fields in Report Filter Area' to 'Down,Then Over' On the Layout & Format tab.
• D) Right-click a cell in the pivot table,and click Pivot Table Options,then set the 'Display Fields in Report Filter Area' to Over,Then Down' On the Layout & Format tab.

---

Definitions:

Ten-speed

A bicycle equipped with ten gears for different speeds and terrains.

Know

To be aware of through observation, inquiry, or information.

Except

Used to indicate a person, thing, or situation that is not included in a statement or category.

Supposed

Accepted as true or as a given premise without definitive evidence, often used to indicate belief or assumption.