Excel Lesson 1 & 2 Review

Chart that use vertical bars

• Bar

• Pie

• Column

• Area

Chart that uses horizontal bars

• Bar

• Pie

• Column

• Scatter

Visual representation of data

• Table

• Spreadsheet

• Chart

• Picture

Chart used to compare a single category of value as parts of a whole

• Column

• Scatter

• Pie

• Area

Identifies the data series each color represents

• Vertical Axis

• Horizontal Axis

• Legend

• Title

What information appears most commonly on the horizontal axis

• Quanities

• Titles

• Data series headings or time frames

• Data series color definitions

Information that appears on the vertical axis

• Data series

• Titles

• Data series headings or time frames

• Even counts of all the values in your data series

Which chart is used to identify the type of relationship between categories and/or variables

• Scatter

• Pie

• Column

• Area

series of points that are plotted on a chart or graph

• Line

• Data series

• Bar

• Data markers

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

• Data table

• Trendline

• Scatter diagram

• Legeng