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:

Employee Layoffs

happen when employees are let go from their jobs due to cost-cutting measures, restructuring, or economic downturns.

Codetermination Rights

Legal rights allowing workers and their representatives to participate in management and decision-making processes within a company.

Works Council

Employee representation bodies within a workplace that consult with management on issues affecting workers, common in many European countries.

Labor Relations

The study and practice of managing relationships between employers and their workforce, often involving labor unions, collective bargaining, and labor laws.