Inserting a slicer on a pivot table

Name:

Date:

Class:

Quick Questions

Shade in the A or B circle for each question.

1. Which menu path adds a slicer to a pivot table?

A Insert > Slicer

B Data > Remove Duplicates

2. A slicer is made for how many fields?

A Every field in the pivot table at once

B One field, such as Region

3. You click the button 'North' on a Region slicer. What happens?

A The pivot table shows only North rows, and the pivot chart updates too

B The North button is deleted from the slicer

4. How do you select several buttons on a slicer at once?

A Double-click the slicer title

B Hold Ctrl and click each button

5. Which field is the best choice for a slicer?

A Region, because it has a few categories to pick from

B Order ID, because it has hundreds of different values

Match the Pairs

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

Left column		Right column
1Insert > Slicer		ASlicer tab > Columns: 3
2Ctrl + click on slicer buttons		BSelects several buttons at once so the pivot table shows more than one item, such as Red and Blue.
3Choosing the field: make a slicer that filters by the house field		CInsert > Slicer > tick house > OK
4Slicer columns and size: show the buttons in 3 columns		DAdds a panel of buttons for one field that you click to filter the pivot table and its pivot chart.
5Click a slicer button, then click another to select both		EA normal click selects only one button. The second click replaces the first, so only one item is shown.
6Insert > Slicer > tick house and year level to make one slicer with both fields		FA slicer filters only one field. Ticking two fields creates two separate slicers, not one slicer with both.

Definitions

Insert > Slicer

Fill in the Blanks

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

Insert > ______

______ > Slicer

Hold ____ and click to pick several buttons

Slicer tab > _______ sets buttons per row

Insert Slicers box: tick one _____, then OK

Spot the Error

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

Question 1

A Click in the pivot table

B Go to Insert > Slicer

C Tick the Points total field

D Click OK

Question 2

A Click in the pivot table

B Go to Insert > Slicer

C Tick the Year field

D Click Cancel to add it

Question 3

A Click the slicer button Red

B Hold Ctrl and click Blue

C The table shows only Red

Question 4

A Click the slicer

B Go to the Slicer tab

C Set Rows to 3

Question 5

A Click the slicer

B Open the Slicer tab

C Find the Size group

D Type a new slicer Title

Answer Key

Inserting a slicer on a pivot table

Section A: Quick Questions

A — Insert > Slicer

B — One field, such as Region

A — The pivot table shows only North rows, and the pivot chart updates too

B — Hold Ctrl and click each button

A — Region, because it has a few categories to pick from

Section B: Match the Pairs

Insert > Slicer → Adds a panel of buttons for one field that you click to filter the pivot table and its pivot chart.

Ctrl + click on slicer buttons → Selects several buttons at once so the pivot table shows more than one item, such as Red and Blue.

Choosing the field: make a slicer that filters by the house field → Insert > Slicer > tick house > OK

Slicer columns and size: show the buttons in 3 columns → Slicer tab > Columns: 3

Click a slicer button, then click another to select both → A normal click selects only one button. The second click replaces the first, so only one item is shown.

Insert > Slicer > tick house and year level to make one slicer with both fields → A slicer filters only one field. Ticking two fields creates two separate slicers, not one slicer with both.

Section C: Definitions

Insert > Slicer — Adds a panel of buttons for one field. Click a button to filter the pivot table and its pivot chart. Hold Ctrl to select several buttons at once.

Section D: Fill in the Blanks

Insert > Slicer

Hold Ctrl and click to pick several buttons

Slicer tab > Columns sets buttons per row

Insert Slicers box: tick one field, then OK

Section E: Spot the Error

C — A slicer filters by a field of categories such as House. A calculated total like the sum of points gives no useful buttons. It should be: Tick the House field.

D — Cancel closes the Insert Slicers box without making a slicer. Click OK to add the slicer.

C — Holding Ctrl while clicking lets you select several buttons at once, so the pivot table shows both Red and Blue, not only Red.

C — The Slicer tab has a Columns box that arranges the buttons in a grid. There is no Rows setting. It should be: Set Columns to 3.

D — The Size group is where you set the slicer's Height and Width. Changing the title only changes the caption, not the size.