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 | c. | Data point | d. | Data series | | |
|
|
|
40.
|
In a chart,
each data point is visually represented by a ____. a. | Data
marker | b. | Tick mark | c. | Data point | d. | Data series | | |
|
|
|
41.
|
Each value
selected for a chart is called a ____. a. | Data marker | b. | Tick mark | c. | Data point | d. | Data series | | |
|
|
|
42.
|
On a chart
created in Excel, the horizontal axis is called the ____. a. | X-axis | b. | Y-axis | c. | Data marker | d. | Legend | | |
|
|
|
43.
|
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 | | |
|
|
|
44.
|
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 | | |
|
|
|
45.
|
To show how
volume changes over time use a(n) ____. a. | Area chart | b. | Bar chart | c. | Column chart | d. | Line
chart | | |
|
|
|
46.
|
Which type
of chart best shows the relationship of parts to a whole?
|
|
|
47.
|
The Excel
program defaults to a(n) ____ chart. a. | Area | b. | Bar | c. | Column | d. | Line | | |
|
|
|
48.
|
Which chart
types are part of a combination chart? a. | Bar and column | b. | Column and
line | c. | Line and
bar | d. | Pie and
column | | |
|
|
|
49.
|
Which type
of chart would best show the total volume of June sales, divided by each of four
territories? a. | Scatter | b. | Pie | c. | Bar | d. | Line | | |
|
|
|
50.
|
Which two
charts compare trends over time intervals? a. | Bar and pie | b. | Pie and area | c. | Area and
line | d. | Line and XY
(scatter) | | |
|
|
|
51.
|
Which chart
type would you use to compare unrelated objects over time using a horizontal format? a. | Area | b. | Bar | c. | Column | d. | Line | | |
|
|
|
52.
|
To delete a
chart, select it and then press ____. a. | Tab | b. | Enter | c. | Delete | d. | Esc | | |
|
|
|
53.
|
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 | | |
|
|
|
54.
|
You can
rotate a 3-dimensional chart to ____. a. | Get a better fit on the page | b. | Get a better view of
columns | c. | Reduce it to 2-dimensions | d. | Reverse the
axes | | |
|
|
|
55.
|
You can
easily change chart types using buttons on the ____ toolbar. a. | Chart | b. | Edit | c. | Chart Type | d. | Rotate | | |
|
|
|
56.
|
Which of the
following statements is NOT true of Excel charts? a. | Charts are easy to modify. | b. | It is easy to change a
chart type. | c. | If you change data values in a worksheet, the chart is automatically
updated. | d. | Excel charts cannot override Chart Wizard
recommendations. | | |
|
|
|
57.
|
All of the
following charts can be created in Excel by pressing a chart button EXCEPT ____. a. | Bar | b. | 3-dimensional line | c. | Radar | d. | Flow | | |
|
|
|
58.
|
Text
annotations are ____ that you add to draw attention to a certain part of a chart. a. | Arrows | b. | Titles | c. | Labels | d. | Notes | | |
|
|
|
59.
|
In a pie
chart, slices that are pulled away are said to be ____. a. | Identified | b. | Exploded | c. | Opened | d. | Strayed | | |
|
|
|
|
|
|
60.
|
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 | | |
|
|
|
61.
|
In the
figure above, item 1 points to the ____. a. | Chart options | b. | Sample
chart | c. | Labels | d. | Selection handles | | |
|
|
|
62.
|
In the
figure above, item 2 points to the ____. a. | Legend | b. | Chart title | c. | Worksheet title | d. | None of the
above | | |
|
|
|
|
|
|
63.
|
In the
figure above, which item number would you select to create a chart comparing distinct, unrelated
objects overtime?
|
|
|
64.
|
In the
figure above, which item number would you choose to create a chart that compares trends over even
time intervals?
|
|
|
65.
|
The figure
above illustrates the 18 chart types in the ____. a. | Chart Type palette | b. | Chart Enhancement list
box | c. | Chart Wizard dialog
box | d. | None of the
above | | |
|
|
|
66.
|
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 | | |
|
|
|
67.
|
In the
figure above, item 4 allows you to create a ____ chart a. | 3-D
cylinder | b. | 3-D cone | c. | 3-D area | d. | 2-D area | | |
|
Completion
Complete each sentence or
statement.
|
|
|
68.
|
The
____________________ axis is the horizontal axis.
|
|
|
69.
|
Data points
are visually represented by a data ____________________.
|
|
|
70.
|
The
____________________ axis is the vertical axis.
|
|
|
71.
|
A(n)
____________________ identifies the data series in a chart.
|
|
|
72.
|
The
____________________ marks on the y-axis create a scale of measure for each value.
|
|
|
73.
|
The Excel
default chart type is the ____________________ chart.
|
|
|
74.
|
A(n)
____________________ chart shows how volume changes over time.
|
|
|
75.
|
A bar chart
compares distinct, unrelated objects over time using a(n) ____________________ format.
|
|
|
76.
|
A column
chart compares distinct, unrelated objects over time using a(n) ____________________
format.
|
|
|
77.
|
A
combination chart includes a line and a(n) ____________________ chart.
|
|
|
78.
|
A(n)
____________________ chart shows the relationship of parts to a whole.
|
|
|
79.
|
Sizing
____________________ are small black squares at the corners and sides of the chart's border,
indicating the chart is selected.
|
|
|
80.
|
You can
erase a chart from a worksheet by selecting it and pressing ____________________.
|
|
|
81.
|
Charts are
graphics, or drawn ____________________, and have no specific cell or range address.
|
|
|
82.
|
The Chart
Objects list box appears on the ____________________ toolbar.
|
|
|
83.
|
Most charts
can be viewed in two-dimensional and ____________________-dimensional forms.
|
|
|
84.
|
You can
____________________ a 3-dimensional chart to get a better view of columns or bars.
|
|
|
85.
|
____________________ are the horizontal lines in the chart that enable you to follow
the value on an axis.
|
|
|
86.
|
You can
change the color of a data series by using the ____________________ Data Series dialog
box.
|
|
|
87.
|
To change
the font and font size of a chart's axis text, ____________________-click the text to open the Format
Axis dialog box.
|
|
|
88.
|
Additional
labels that highlight information in a chart are called ____________________
annotations.
|
|
|
89.
|
To add an
arrow to a section of a chart, click the arrow button on the ____________________
toolbar.
|
|
|
90.
|
You can
emphasize a pie slice in a pie chart by ____________________ it, or pulling it away from the pie
chart.
|
|
|
91.
|
You can
print a chart in portrait or ____________________ orientation.
|
|
|
92.
|
____________________ orientation turns the page sideways.
|
|
|
93.
|
To change
the orientation of the page, open the Page ____________________ dialog box.
|
|
|
94.
|
To see what
your chart will look like before it is printed, click the ____________________ button on the Standard
toolbar.
|
|
|
95.
|
Placing the mouse pointer over a chart object displays an identifying
____________________.
|
|
|
|
|
|
96.
|
The figure
above illustrates the Chart Options ____________________ box.
|
|
|
97.
|
In the
figure above, item 1 indicates the Gridlines ____________________ has been selected.
|