Spreadsheet Essentials L2 (Charts)

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

• bar

• pie

• area

• column

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

• pie

• bar

• column

• scatter

A ___________________ is a visual representation of data.

• spreadsheet

• border

• chart

• table

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

• Bar

• Pie

• Scatter

• Column

A chart ________________ identifies which data series each color represents.

• legend

• vertical axis

• horizontal axis

• title

What information appears most commonly on the horizontal axis?

• Quantities

• Data series headings or time frames

• Data series color definitions

• Titles

What information appears on the vertical axis?

• Data series color definitions

• Titles

• Even counts of all the values in your data series

• Data series headings or time frames

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

• Scatter

• Pie

• Column

• Area

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

• line

• data markers

• data series

• bar

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

• trendline

• data table

• scatter diagram

• legend