Slicers and interactive filters

Name:

Date:

Class:

Quick Questions

Shade in the A or B circle for each question.

1. A slicer is a set of buttons that filters a table, pivot table or chart when you click it.

A True

B False

2. Your pivot table shows sales for Years 7 to 10. Which tool lets a viewer click a button to see only Year 9?

A A slicer

B A chart title

3. Which is the best way to add a slicer in a spreadsheet?

A Click the pivot table or chart, then choose Insert > Slicer and pick a field

B Type =SLICER() into a cell and press Enter

4. A slicer is linked to a column chart. You click the 'Term 2' button. What happens to the chart?

A The chart is deleted and replaced by a new one

B The chart updates to show only the Term 2 data

5. You have filtered a table with a slicer and now want to see all the data again. What should you do?

A Delete the original data and re-enter it

B Clear the filter on the slicer

Match the Pairs

Draw a line connecting each item on the left to its match on the right.

Left column		Right column
1Insert > Slicer		AAdds a slicer: a set of buttons you can click to filter a table, pivot table or chart
2Clear Filter button (X icon)		BSlicer: Year = 2024 -> chart shows only 2024
3A slicer linked to a chart changes the chart when you click a button		CDeleting the slicer is not needed and removes the buttons. Use Clear Filter instead to show everything while keeping the slicer.
4A slicer lets viewers explore data interactively, with no need to edit the table		DThe slicer is not linked to the table, pivot table or chart, so clicking a button filters nothing. Connect it to the data.
5Slicer: Sport = Netball -> sheet still shows every sport		ERemoves the slicer's filter so all the data is shown again
6Delete the slicer to show all the data again		FClick the 'Netball' button to see only Netball rows

Definitions

slicer

Fill in the Blanks

Complete each line of code by filling in the missing parts.

______ > Slicer > choose the Region field

A ______ has buttons that filter data

Select the _____, then Insert > Slicer

Click a button to ______ the linked chart

Click Clear ______ to show all the data

Spot the Error

Shade in the letter of the line that contains an error.

Question 1

A Click inside the pivot table

B Insert > Chart

C Tick the Region field

D Click OK to add the slicer

Question 2

A s = AddSlicer(Sales,"Day")

B s.Select("Mon")

C s.Delete()

Question 3

A s = AddSlicer(Sales,"Team")

B s.LinkTo(Team)

C s.Select("Blue")

Question 4

A s = AddSlice(Sales,"Region")

B s.Select("West")

C Sales shows only West rows

Question 5

A s = AddSlicer(Sales,"Day")

B click "Mon" -> only Mon rows

C click "Tue" -> only Mon rows

Answer Key

Slicers and interactive filters

Section A: Quick Questions

A — True

A — A slicer

A — Click the pivot table or chart, then choose Insert > Slicer and pick a field

B — The chart updates to show only the Term 2 data

B — Clear the filter on the slicer

Section B: Match the Pairs

Insert > Slicer → Adds a slicer: a set of buttons you can click to filter a table, pivot table or chart

Clear Filter button (X icon) → Removes the slicer's filter so all the data is shown again

A slicer linked to a chart changes the chart when you click a button → Slicer: Year = 2024 -> chart shows only 2024

A slicer lets viewers explore data interactively, with no need to edit the table → Click the 'Netball' button to see only Netball rows

Slicer: Sport = Netball -> sheet still shows every sport → The slicer is not linked to the table, pivot table or chart, so clicking a button filters nothing. Connect it to the data.

Delete the slicer to show all the data again → Deleting the slicer is not needed and removes the buttons. Use Clear Filter instead to show everything while keeping the slicer.

Section C: Definitions

slicer — A set of buttons linked to a table, pivot table or chart. Click a button to filter the data, so a viewer can explore it interactively. Clear the filter to show everything again.

Section D: Fill in the Blanks

Insert > Slicer > choose the Region field

A slicer has buttons that filter data

Select the chart, then Insert > Slicer

Click a button to filter the linked chart

Click Clear Filter to show all the data

Section E: Spot the Error

B — To add a slicer you choose Insert > Slicer. Insert > Chart would add a chart, not a set of filter buttons.

C — Clearing the filter shows all the data again, so it should be s.ClearFilter(). Deleting the slicer is not the same as clearing its filter.

B — A slicer is linked to a chart (or table), not to a field name. It should be s.LinkTo(Chart1) so the chart changes when a button is clicked.

A — The function is called AddSlicer, not AddSlice. It should be s = AddSlicer(Sales,"Region").

C — Clicking the Tue button filters the data to Tuesday rows. It should say only Tue rows, not Mon rows.