Which steps describe filtering a table by Category values Coffee or Meals using a slicer?

Which steps describe filtering a table by Category values Coffee or Meals using a slicer?

• A. Design > Tools > Insert Slicer > Category checkbox > Click multiselect > select everything EXCEPT Coffee/Meals
• B. Design > Tools > Insert Slicer > Category checkbox > Click multiselect > select Coffee and Meals
• C. Insert > Slicer > Category > select Coffee and Meals
• D. Analyze > Slicer > Category > include Coffee and Meals

Answer: (A)

Using a slicer to filter by specific category values works by binding a slicer to the Category field and enabling multi-select. To show only items in Coffee or Meals, you open the slicer, turn on multiselect, and choose Coffee and Meals. The table then updates to display only rows where Category is Coffee or Meals. Selecting everything except Coffee and Meals would do the opposite, filtering out those two categories and showing all others, which isn’t the goal here.

Using a slicer to filter by specific category values works by binding a slicer to the Category field and enabling multi-select. To show only items in Coffee or Meals, you open the slicer, turn on multiselect, and choose Coffee and Meals. The table then updates to display only rows where Category is Coffee or Meals. Selecting everything except Coffee and Meals would do the opposite, filtering out those two categories and showing all others, which isn’t the goal here.