Test 11 - Pivot Table and Slicer

When you create a Pivot Table, your data must be in a Table beforehand.

• True

• False

You can only have one Pivot Table in a worksheet.

• True

• False

What combination of settings was used to create this Pivot Table?

• 
• 
• 
• 

Uma has just watched the video on creating Pivot Tables and she is excited that you don't need to highlight the whole data range to create a pivot table, all you need to do is make sure that you are clicked on one of the cells in the data range. Has Uma understood the topic well?

• Yes, of course you have to indicate to Excel where to find the data by being clicked in one of the cells that contains the data.

• No, you can just specify the table/range and Excel will know where the data is located.

Which of the following is NOT part of a Pivot Tables?

• Calculated item

• Slicers

• Sparklines

• Calculated Field

You can easily style Pivot Tables in a similar way to Tables.

• True

• False

Which of the following statements are true for Pivot Tables?

• You can apply different functions - average, count, etc - to numeric fields

• Numeric values can only be summed

• Count can only be applied to text fields

• You can use a text field in the Values area

Which of the following methods would enable me to show the Count instead of the Sum of Total?

• Right-click on any cell in the Sum of Total field and going to Value Field Settings and under Summarise Values By, find Count.

• Drag a text field into Values area and remove the Total field.

• Right-click on any cell under the Sum of Total field, go to Summarize Values By and change it to Count.

• Right-click on any cell under the Sum of Total field and go to Show Values As and choose Count.

To form a grouping like a grouping by quarter and year I have to:

• Click on one of the cells included in that field and right-click and go to Group.

• Click on one of the cells included in that field and go to Group selection in the Analyze tab (in the Group tools).

• You can be clicked anywhere in the pivot table and go to Analyze tab and go to Group field in the Group tools.

Sean has applied a filter to the row and column, he now wants to remove the column filter. Uma suggests that he can go to the Data tab in the ribbon and press Clear in the Sort & Filter tools. Is Uma right?

• Yes

• No