Excel - Pivot tables and Pivot charts

What can you use to easily filter pivot tables interactively in a worksheet?

• Slicer

• Cutter

• Division

• Sliver

John wants to create a chart that shows trends of sales for four quarters. What type of chart should he create?

• Pivot Chart
• Line Chart
• Embedded Chart
• Linked Chart

What is the purpose of the -/+ buttons that appear across the categories on a PivotTable?

• Decrease/Increase

• Collapse/Expand

• Reduce/Add

• Subtract/Add

John wants to add text effects to his PivotChart. Which PivotTable Chart Tools tab would he use?

• Design
• Format
• Layout
• Analyze

John has created a Pivot chart and would like to include a guide that would display the names of the series of data included on the chart. Which option would allow him to do this?

• Report Filter
• Legend Fields
• Axis Fields
• Values

In order to directly report the data, what must a PivotChart always be associated with?

• Table
• Range
• PivotTable
• Worksheet

Which is the name of an interactive graphical representation of data that allows a user to change the groupings?

• PivotChart

• PivotTable

• PivotDate

• Rotate Table

What ribbon contains the commands used to create a chart in Excel?

• Home Ribbon
• Insert Ribbon
• Formula Ribbon
• Data Ribbon

John wants to change the chart style on his Pivot table. Which Pivot Table chart tools tab would he choose?

• Design
• Layout
• Formula
• Analyze

What are graphical objects that contain buttons a user can click to filter the data in PivotTables and PivotCharts?

• Slivers
• Partials
• Slicers
• Movers