Question

In order to use Slicers to filter some data, what must you first do to that data?

Answer 1

Answer:

Select the fields you'd like to filter, Select OK and adjust your slicer preferences, such as Columns, under Options.To select more than one item, hold Ctrl and then select the items that you want to show.

Explanation:

Answer 2

Answer:

Select Insert > Slicer. Select the fields you'd like to filter. Select OK and adjust your slicer preferences, such as Columns, under Options. To select more than one item, hold Ctrl, and then select the items that you want to show.

Explanation: Convert the data into a table