Excel - Lesson 12

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

Dorothy designed a column chart and would like to change the background color to yellow. Which chart feature would she modify?

• Axis Title
• Chart Title
• Gridlines
  
• Plot Area

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

John wants to identify the exact value that each column in his chart represents. Which option should he choose?

• Gridlines
• Pictures
• Labels
• Arrows

John wants to be able to view his monthly sales chart as well as his data on the same worksheet. What type of chart should he create?

• PivotChart
• Line Chart
• Embedded Chart
• Linked Chart