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 Exporting

The process of selling goods and services from one country directly to customers in another country without using intermediaries.

Foreign Agent

An individual or organization that represents the interests of a foreign country within another nation, often required to register with the local government.

Commercial Activity

Business activities focused on the exchange of goods or services with the intent to earn profit.

Natural Resources

Raw materials and resources naturally occurring in the environment, such as minerals, forests, and water.