Lesson 1 & 2 Excel Review

Which of the following charts uses vertical bars to display data?

• Pie

• Bar

• Column

• Scatter

Which of the following charts uses horizontal bars to display data?

• Bar

• Column

• Area

• Scatter

Which is a visual representation of data?

• Spreadsheet

• Chart

• Picture

• Border

Which of the following charts is used to compare a single category of values as parts of a whole?

• Pie

• Column

• Scatter

• Bar

Identifies which data series each color represents.

• Vertical Axis

• Legend

• Horizontal Axis

• Title

What information appears most commonly on the horizontal axis?

• Titles

• Quantities

• Data series headings or time frames

• data series color definitions

What information appears on the vertical axis?

• Titles

• Legend

• Data series defintions

• Even counts of all values in your data series

Which of the following charts is used to identify the type of relationship (if any) between categories and/or variables?

• Pie

• Area

• Bar

• Scatter

A series of points that are plotted on a chart or graph.

• Line

• Bar

• Data series

• Data markers

Used to show a common attribute or trend among your data points.

• Legend

• Data series

• scatter diagram

• Trendline