How Would You Add a Date Filter to a PivotTable

question 15

Multiple Choice

How would you add a date filter to a PivotTable with these fields: Date, Category, Item, Unit Price, Number Sold, and Extended Price?

• A)remove Date from any PivotTable area
• B)drag Date to the ROWS area and group it.
• C)drag the Date field to the FILTERS area.
• D)You must use a slicer with dates.

---

Definitions:

Knowledge

The facts, information, and skills acquired through experience or education; the theoretical or practical understanding of a subject.

Salesperson Knowledge

The information and skills that a sales representative possesses, which can include product details, market insights, and customer service techniques.

Product

Any item or service offered for sale, designed to meet a specific need or demand in the market.

Service

Making a contribution to the welfare of others; the product which is an action or activity done for others for a fee.