True/False
Indicate whether the
statement is true or false.
|
|
|
1.
|
A worksheet is a much more effective way to communicate data to an audience than
a chart.
|
|
|
2.
|
Excel 2007 provides many tools for creating charts to help you communicate key
trends and facts about your worksheet data.
|
|
|
3.
|
A legend is a chart symbol, such as a bar, that portrays one series
value.
|
|
|
4.
|
You can create Excel charts from your worksheet data automatically.
|
|
|
5.
|
You cannot change the chart type after creating a chart.
|
|
|
6.
|
To change the size of a chart, you must recreate it.
|
|
|
7.
|
You can modify individual chart elements, such as moving the legend or changing
the color of a data series, but a faster way to make changes is to apply overall layouts and
styles.
|
|
|
8.
|
When you create a chart, each chart object has default settings applied.
|
|
|
9.
|
A data table in a chart is a grid containing the chart’s underlying
worksheet data.
|
|
|
10.
|
Excel only has a few styles and effects to improve the appearance of a chart and
increase its visual appeal and effectiveness.
|
Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
11.
|
____ are lines in a chart that make it easier to identify the value for each
data series.
a. | Data lines | c. | Gridlines | b. | Data markers | d. | Grid markers |
|
|
|
|
|
|
12.
|
In the accompanying figure, item 2 points to the ____.
a. | chart gridlines | c. | data marker | b. | chart title | d. | data series |
|
|
|
13.
|
In the accompanying figure, item 6 points to the ____.
a. | x-axis | c. | axis titles | b. | y-axis | d. | data series |
|
|
|
|
|
|
14.
|
In the accompanying figure, item 1 points to the ____.
a. | ScreenTip | c. | Insert tab | b. | Line button | d. | Line subtype |
|
|
|
15.
|
In the accompanying figure, item 3 points to the ____.
a. | ScreenTip | c. | Insert tab | b. | Line button | d. | Line subtype |
|
|
|
16.
|
In the accompanying figure, item 4 points to the ____.
a. | ScreenTip | c. | Insert tab | b. | Line button | d. | Line subtype |
|
|
|
17.
|
To resize a chart object, drag one of its ____.
a. | sizing handles | c. | resize boxes | b. | dragging handles | d. | resize buttons |
|
|
|
|
|
|
18.
|
In the accompanying figure, item 1 points to the ____.
a. | data series | c. | Switch Row/Column button | b. | legend | d. | Chart Tools Design tab |
|
|
|
19.
|
In the accompanying figure, item 2 points to the ____.
a. | data series | c. | Switch Row/Column button | b. | legend | d. | Chart Tools Design tab |
|
|
|
20.
|
In the accompanying figure, item 4 points to a ____ chart.
a. | pie | c. | bubble | b. | bar | d. | stack |
|
|
|
21.
|
A ____ in a chart is a grid containing the chart’s underlying worksheet
data, which is added below the x-axis in certain types of charts.
a. | grid table | c. | data list | b. | data table | d. | data box |
|
|
|
22.
|
You can choose from a variety of commands and galleries on the ____ Format tab
to make enhancements and adjustments to a selected chart object.
a. | Chart | c. | Chart Tools | b. | Tools | d. | Graph Tools |
|
|
|
23.
|
____ charts are great for comparing values across categories.
a. | Pie | c. | Bubble | b. | Column | d. | Circle |
|
|
|
24.
|
A ____ chart is an effective tool for comparing the relative values of parts to
a whole.
a. | Pie | c. | Bubble | b. | Column | d. | Circle |
|
|
|
25.
|
You can add text to a ____ at the top of the page.
a. | caption | c. | header | b. | block | d. | footer |
|
Matching
|
|
|
Match each item with a statement below. a. | radar | d. | bubble | b. | stock | e. | line | c. | area |
|
|
|
26.
|
The chart type that shows the relative importance of values over a period of
time
|
|
|
27.
|
The chart type that shows trends by category over time
|
|
|
28.
|
The chart type that shows changes in data or data frequency relative to a
center point
|
|
|
29.
|
The chart type that compares three sets of values
|
|
|
30.
|
The chart type that compares High, Low, and Close values
|