True/False
Indicate whether the sentence or statement is true
or false.
|
|
|
1.
|
Data points
exist only on the y-axis.
|
|
|
2.
|
A collection
of related data points in a chart is called a data series.
|
|
|
3.
|
Each value
in a chart is called a data series.
|
|
|
4.
|
Charts are
derived from worksheet data.
|
|
|
5.
|
Tick marks
create a scale of measure for each value on the y-axis.
|
|
|
6.
|
A chart's
vertical axis is called the y-axis.
|
|
|
7.
|
A collection
of tick marks requires a legend.
|
|
|
8.
|
A bar chart
compares distinct, unrelated objects over time using a horizontal format.
|
|
|
9.
|
An area
chart shows the relationship of parts to a whole.
|
|
|
10.
|
A line chart
compares trends over even time intervals.
|
|
|
11.
|
A pie chart
is mainly used in scientific disciplines.
|
|
|
12.
|
The Excel
program defaults to a column chart.
|
|
|
13.
|
Both area
and pie charts can be used to show changes over time.
|
|
|
14.
|
A pie chart
shows changes in data over long periods of time.
|
|
|
15.
|
A
combination chart combines a column and line chart to compare data requiring different scales of
measure.
|
|
|
16.
|
The Chart
Wizard uses a series of dialog boxes.
|
|
|
17.
|
Selection
handles are small black squares at the corners and sides of the chart's border that indicate the
chart is in Design mode.
|
|
|
18.
|
When you
select a cell, Chart Wizard will allow you to create a chart.
|
|
|
19.
|
The Chart
Wizard button is located on the Edit menu.
|
|
|
20.
|
You can move
charts anywhere on a worksheet without affecting formulas or data in the worksheet.
|
|
|
21.
|
You cannot
change the position of a legend.
|
|
|
22.
|
To deselect
a chart element, double click the selection handle.
|
|
|
23.
|
To
manipulate data in a chart, you must first change the data in the worksheet.
|
|
|
24.
|
If you
change data values in a worksheet, the chart will be updated automatically to reflect the new
data.
|
|
|
25.
|
If columns
are obscured in a 3-dimensional chart, you can rotate the chart for a better view.
|
|
|
26.
|
To rotate a
chart, you must double-click the chart then select Flip on the Edit menu.
|
|
|
27.
|
Gridlines
are the horizontal lines in the chart that enable the eye to follow the value on an
axis.
|
|
|
28.
|
Chart
enhancement buttons are on the Formatting toolbar.
|
|
|
29.
|
The Format
Data Series dialog box allows you to change the patterns on a chart.
|
|
|
30.
|
In a pie
chart, slices that are pulled away are referred to as "exploded."
|
|
|
31.
|
The
Chart menu only appears on the menu bar when a chart or one of its objects is selected.
|
|
|
32.
|
You
can add a text annotation to a chart using the Chart toolbar.
|
|
|
|
|
|
33.
|
In the
figure above, item 2 points to a sample chart with gridlines.
|
|
|
34.
|
In the
figure above, item 3 indicates the x-axis gridlines have NOT been selected.
|
Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
35.
|
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 | | |
|
|
|
36.
|
A(n) ____
identifies each data series in a chart. a. | Axis | b. | Data point | c. | Data marker | d. | Legend | | |
|
|
|
37.
|
The x-axis
and y-axis are, respectively, the ____. a. | Horizontal and vertical axes | b. | Data
series | c. | Tick markers | d. | Vertical and horizontal
axes | | |
|
|
|
38.
|
Before
creating a chart, do all of the following EXCEPT ____. a. | Plan what you want the
chart to show | b. | Decide the color of the chart and background | c. | Decide how you want the
chart to look | d. | Decide what chart type is most appropriate | | |
|
|
|
39.
|
A collection
of related data points is called a ____. a. | Data marker | b. | Tick marks | |
|