Spreadsheet Essentials- Lesson 2: Working with Charts and Tables

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

• Bar

• Area

• Pie

• Column

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

• Pie

• Column

• Bar

• Scatter

A ___________________ is a visual representation of data.

• spreadsheet

• chart

• border

• table

A chart ________________ identifies which data series each color represents.

• legend

• title

• vertical axis

• horizontal axis

What information appears most commonly on the horizontal axis?

• Quantities

• Data series color definitions

• Data series headings or time frames

• Titles

What information appears on the vertical axis?

• Data series color definitions

• Even counts of all the values in your data series

• Titles

• Data series headings or time frames

Which of the following charts is used to identify the type of relationship between categories?

• Scatter

• Column

• Pie

• Area

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

• data series

• data markers

• line

• bar

What information is contained in a data label?

• Data series names

• Category names

• Data point values

• Axis values

A _______________ is used to show a common attribute or trend among your data points.

• trendline

• scatter diagram

• data table

• legend