Excel Questions Chapter 12

Which is a tiny chart that provides a visual representation of data in a worksheet

cell?

• Trendline

  d.

• b. Sparkline

• Dataline

• Flashpoint

What is the process of viewing a PivotTable report for a subset that meets the

criterion

only?

• Filtering

• Positioning

• Sorting

• Arranging

Leigh Ann designed a bar chart and would like to add an element to the right of

the

chart that identifies each bar;s color. Which chart feature would she need to

include?

• Axis

• Chart title

• Data label

• Legend

What ribbon contains the commands for creating charts in Microsoft Excel?

• Home

• Page Layout

• Insert

• Data

Edward would like to create a chart that shows the trend in iPod sales over the

past 2

years. Which chart type should he create?

• Bar

• Column

• Insert

• Data

Edward would like to create a chart that shows the trend in iPod sales over the

past 2

years. Which chart type should he create?

• Style

• Design

• Layout

• Format

John wants to change the chart style on his PivotTable. Which PivotTable chart

tools

tab would he create?

• Design

• Layout

• Format

• Analyze