ICT Spreadsheet Essentials Graphs

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

What information is contained in a data label?

• axis values

• category names

• data point values

• data series names

What information appears most commonly on the horizontal axis?

• quantities

• titles

• data series color definitions

• data series headings or time frames

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

• line

• bar

• data series

• data markers

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

• click and drag the series

• click the format painter

• double click on the series

• Ctrl & single click on the series

A _____________identifies the information being displayed in the chart.

• horizontal axis

• legend

• vertical axis

• title

A ________________is a visual representation of data.

• table

• chart

• border

• spreadsheet

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

• data table

• trendline

• legend

• scatter diagram

Which two chart types are the most interchangeable?

• bar and column

• pie and area

• pie and bar

• line and scatter

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

• pie

• scatter

• column

• bar