Excel Pivot Tables

A ____ is an interactive view of worksheet data.

• PivotChart report

• PivotTable report

• 2-D column chart

• trendline

You can change the view of a PivotTable report depending on what you want to analyze.

• True

• False

By default, Microsoft Excel automatically saves a copy of your spreadsheet every 10 minutes.

• True
• False

What can you use to easily filter pivot tables and cube functions 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

What graphically represents trends in plotted data and predicts future values?

• Sparkline
  
• Trendline
  
• Chartline
• Error bar

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

• Design
• Format
• Layout
• Analyze

Leigh Ann designed a bar chart and would like to add an element above the chart to make the data more meaningful. Which chart feature would she need to include?

• Axis
• Chart Title
• Data Label
• Legend

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