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:

Osteoporosis

A medical condition in which the bones become brittle and fragile from loss of tissue, typically as a result of hormonal changes, or deficiency of calcium or vitamin D.

Brittleness

The propensity of a substance to crack or fracture readily under pressure, without substantial bending or distortion.

Presbycusis

Age-related hearing loss that gradually occurs in most individuals as they grow older.

American Newborn

An infant who has recently been born in the United States.