Spreadsheets Lesson 2

A ______________ identifies the information being displayed in the chart.

title

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

trendline

Which of the following charts is used to represent cumulated totals over time, comparing two or more quantities - similar to a line chart?

Area

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

Bar

Which two chart types are the most interchangeable?

Bar and Column

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

Column

What information is contained in a data label?

Data point values

What information appears most commonly on the horizontal axis?

Data series headings or time frames

How can you quickly change the appearance of a data series in your chart?

Double-click on a series

____________ are used to show a margin of error for each data point.

Error bars

What information appears on the vertical axis?

Even counts of all the values in your data series

What command enables you to change the location of your chart?

Move

In most charts, each data series is assigned a color or pattern to uniquely identify it. Which type of chart assigns a color to each data point instead of series?

Pie

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

Scatter

When could you use a right vertical axis on a chart?

When you are measuring two different sets of data.

A ___________________ is a visual representation of data.

chart

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

data series

A chart ________________ identifies which data series each color represents

legend

To delete a chart, click once on the chart to select it and then ____________.

press the delete key on the keyboard.