WorksheetsLESSON TWO STUDY GUIDE
Total questions: 20
Worksheet time: 10mins
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
title
Horizontal axis
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.
trend line
data table
scatter diagram
legend
What information is contained in a data label?
Data series names
data point values
Category names
axis values
____________ are used to show a margin of error for each data point.
Trend lines
Error bars
Guidelines
Vertical axis
A ______________ identifies the information being displayed in the chart.
legend
vertical axis
title
horizontal axis
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?
column
area
pie
scatter
When could you use a right vertical axis on a chart?
When you have too much data for one axis.
When you are measuring two different sets of data.
When you have more than 5 categories.
When you have more than 10 data points.
Which two chart types are the most interchangeable?
pie and area
bar and column
line and scatter
pie and bar
How can you quickly change the appearance of a data series in your chart?
Double-click on a series
Ctrl + single click on a series
Click and drag the series
Click the Format Painter
What command enables you to change the location of your chart?
cut
copy
move
Delete
Which of the following charts is used to represent cumulated totals over time, comparing two or more quantities – similar to a line chart?
column
area
pie
scatter
To delete a chart, click once on the chart to select it and then ____________.
click the X in the top of the window.
press the X key on the keyboard
click and drag the chart off the spreadsheet.
press the delete key on the keyboard.
