Which action adds slicers to filter the data by Date?

Which action adds slicers to filter the data by Date?

• A. Data tab, Sort & Filter group, Add Slicer
• B. Insert tab, Charts group, Slicer
• C. Design tab, Tools group, Insert slicer and select Date
• D. Review tab, Data Tools, Insert Slicer

Answer: (C)

Slicers provide a visual, interactive way to filter your data by a specific field, like Date. To add one, you use the slicer tool and choose the field you want to filter by. The path described—Design tab, Tools group, Insert slicer and select Date—invokes the slicer feature and lets you pick Date, after which a Date slicer appears with buttons for each date value. Clicking these buttons filters the PivotTable or chart instantly, making date-based filtering quick and intuitive. This approach directly creates the slicer and ties it to the Date field, which is exactly how you enable date filtering. Other routes don’t reach the slicer setup for a date field, so they don’t accomplish this interactive date filtering.

Slicers provide a visual, interactive way to filter your data by a specific field, like Date. To add one, you use the slicer tool and choose the field you want to filter by. The path described—Design tab, Tools group, Insert slicer and select Date—invokes the slicer feature and lets you pick Date, after which a Date slicer appears with buttons for each date value. Clicking these buttons filters the PivotTable or chart instantly, making date-based filtering quick and intuitive. This approach directly creates the slicer and ties it to the Date field, which is exactly how you enable date filtering. Other routes don’t reach the slicer setup for a date field, so they don’t accomplish this interactive date filtering.