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:

Direct Contact

Physical interaction between an infected person or contaminant and a susceptible host, leading to the potential transfer of disease.

Condenser

Part of a microscope substage that regulates the amount of light directed on a specimen.

Magnified Specimen

A sample that has been enlarged using a microscope or other magnification tool for detailed examination.

Safety Inspection

A systematic examination of a workplace, equipment, or practices to identify potential hazards and ensure compliance with safety regulations and standards.