Understanding PivotCharts and Slicers 3

Which of the following statements outlines an advantage of using PivotCharts over regular charts?

• They can change what they represent depending on how you pivot the data

• They can be used with Slicers

• A single PivotChart can be used to show the same information as multiple standard charts

• All of the above

What is the best chart type for a PivotChart?

• Pie chart

• Bar chart

• Scatter chart

• None of the above

When you click a label in a Slicer it is a lot like…

• Filtering the data

• Re-formatting the data

• Adding new data

• Validating the PivotTable or PivotChart data

What chart types can you not use with a PivotChart?

• Surface charts

• Stock charts

• Bubble charts

• Scatter charts

• All of the above

What is the best way to modify Slicers?

• Using the Format tools on the Home tab

• Using the Styles tab

• Using the Format Filters tab

• Using the Slicer Tools tab

When you click on a PivotChart, what contextual tabs will you see?

• Options and Design

• Design and Layout

• Design, Layout, Analyze, and Format

• Design, Style, Analysis, and Format

Which of the following statements is true? (Select all that apply.)

• A PivotChart will almost always have an associated PivotTable

• You cannot use a PivotChart on data that has been combined with PowerPivot

• If you pivot the data in a PivotTable, the PivotChart associated with it will not change

• You can refresh the data in a PivotChart

Which of the following combinations is not possible?

• A PivotChart and a PivotTable

• A standard chart and a Slicer

• PowerPivot data, a PivotChart, and a Slicer

• A standard table and a standard chart

Which of the following functions can be used to summarize numerical data in a PivotChart or PivotTable?

• Sum

• Average

• Count

• StdDev

• All of the above

Which of the following is not a recommended data source for a PivotTable or PivotChart?

• A Word document

• An Access Database

• A text file

• A database query