Dana Added a Report Filter to a PivotTable, but the List

question 426

Multiple Choice

Dana added a report filter to a PivotTable, but the list of filter values is long and difficult to use. What can she do to reduce the filter values in the list?

• A) Use a slicer instead of a report filter.
• B) Enter search text in the Search box above the list of field item values.
• C) Sort the PivotTable first.
• D) Use the Approximate Filter feature.

---

Definitions:

Security Features

Measures and tools implemented in software and systems to protect against unauthorized access, data breaches, and other cyber threats.

Adobe Reader

A software application developed by Adobe Systems used for viewing, printing, signing, sharing, and annotating PDF files.

HTML Document

A file containing Hypertext Markup Language, which is the standard language used to create and design web pages and web applications.

Access Form

A user interface element in Microsoft Access used to display, enter, and edit data in a database.