Spreadsheets Charts

What information is contained in a data label?

• Axis values

• Data series names

• Data point values

• Category names

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

• Pie

• Scatter

• Column

• Bar

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

• Vertical axes

• Trendlines

• Error bars

• Gridlines

A chart ________________ identifies which data series each color represents.

• horizontal axis

• legend

• vertical axis

• title

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

• Pie

• Scatter

• Area

• Column

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

• Ctrl + single click on a series

• Double-click on a series

• Click the Format Painter

• Click and drag the series

A ___________________ is a visual representation of data.

• chart

• border

• spreadsheet

• table

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

• Area

• Pie

• Bar

• Column

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?

• Area

• Column

• Scatter

• Pie

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

• press the delete key on the keyboard.

• click the X in the top of the window.

• press the X key on the keyboard.

• click and drag the chart off the spreadsheet.