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:

Reasonable Value

An estimation of the fair or proper cost, worth, or price of goods or services in the marketplace.

Disaffirmed

The act of denying, rejecting, or declaring a contract or agreement void, especially in legal contexts involving minors or parties lacking capacity.

Minor

A person who is below the age of majority, legally considered not old enough to take responsibility for legal decisions.

Mental Impairment

A condition that limits a person's intellectual functioning or emotional wellbeing.