Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
1.
|
What indicates the scale of measure for each value on the y-axis?
a. | Data points | b. | Tick marks | c. | Data
markers | d. | Data series |
|
|
|
2.
|
A(n) ____ identifies each data series in a chart.
a. | Axis | b. | Data point | c. | Data
marker | d. | Legend |
|
|
|
3.
|
A collection of related data points is called a ____.
a. | Data marker | b. | Tick marks | c. | Data
point | d. | Data series |
|
|
|
4.
|
Each value selected for a chart is called a ____.
a. | Data marker | b. | Tick mark | c. | Data
point | d. | Data series |
|
|
|
5.
|
On a chart created in Excel, the horizontal axis is called the ____.
a. | X-axis | b. | Y-axis | c. | Data
marker | d. | Legend |
|
|
|
6.
|
On a chart created in Excel, the vertical axis is called the ____.
a. | X-axis | b. | Y-axis | c. | Z-axis | d. | None of the
above |
|
|
|
7.
|
An XY (scatter) chart ____.
a. | Compares distinct, unrelated objects over time using a horizontal
format | b. | Compares trends over even time intervals | c. | Compares trends over
uneven time or measurement intervals | d. | Combines a column and line chart to compare
data requiring different scales of measure |
|
|
|
8.
|
Which type of chart best shows the relationship of parts to a whole?
|
|
|
9.
|
Which chart type would you use to compare unrelated objects over time using a
horizontal format?
a. | Area | b. | Bar | c. | Column | d. | Line |
|
|
|
10.
|
To delete a chart, select it and then press ____.
a. | Tab | b. | Enter | c. | Delete | d. | Esc |
|
|
|
11.
|
Excel leads you through the chart creation process when you click the ____
button on the Standard toolbar.
a. | Chart Wizard | b. | Selection handles | c. | Format
Chart | d. | None of the above |
|
|
|
12.
|
You can easily change chart types using buttons on the ____ toolbar.
a. | Chart | b. | Edit | c. | Chart
Type | d. | Rotate |
|
|
|
13.
|
Text annotations are ____ that you add to draw attention to a certain part of a
chart.
a. | Arrows | b. | Titles | c. | Labels | d. | Notes |
|
|
|
14.
|
In a pie chart, slices that are pulled away are said to be ____.
a. | Identified | b. | Exploded | c. | Opened | d. | Strayed |
|
|
|
|
|
|
15.
|
In the figure above, item 3 points to the chart legend that identifies the four
____.
a. | Sample charts | b. | Chart axes | c. | Data
series | d. | Sales territories |
|
|
|
16.
|
In the figure above, item 1 points to the ____.
a. | Chart options | b. | Sample chart | c. | Labels | d. | Selection
handles |
|
|
|
17.
|
In the figure above, item 2 points to the ____.
a. | Legend | b. | Chart title | c. | Worksheet
title | d. | None of the above |
|
|
|
|
|
|
18.
|
In the figure above, which item number would you select to create a chart
comparing distinct, unrelated objects overtime?
|
|
|
19.
|
In the figure above, which item number would you choose to create a chart that
compares trends over even time intervals?
|
|
|
20.
|
In the figure above, item 3 allows you to create a ____ chart.
a. | 3-D pie | b. | 2-D pie | c. | 2-D
area | d. | None of the above |
|