True/False
Indicate whether the sentence or statement is true
or false.
|
|
|
1.
|
Charts make
it easier to visually detect changes in data.
|
|
|
2.
|
You would
use a bar chart to show the relationship of parts to a whole.
|
|
|
3.
|
When
creating a new chart sheet you must first cut and paste the data that is to be included in the
chart.
|
|
|
4.
|
When the Fit
selection zoom option is chosen, the sheet will automatically be sized to fit the
screen.
|
|
|
5.
|
If you
change the data in a worksheet, the changes will automatically be reflected in any charts that are
based on that data.
|
|
|
6.
|
If you click
the Print button on the toolbar you cannot change the printing options and the sheet will
automatically be sent to the printer.
|
|
|
7.
|
An embedded
chart is on a separate sheet than the data it represents.
|
|
|
8.
|
You can
change the border and color of the chart background and the font and font size of characters in the
chart area in the Format Plot Area dialog box.
|
Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
9.
|
Which of the
following chart types shows values in what’s referred to as “slices”? a. | column | c. | scatter | b. | doughnut | d. | pie | | | | |
|
|
|
10.
|
Which chart
items are headings that identify the contents of the chart or the axes of the chart? a. | data
labels | c. | headings | b. | titles | d. | legends | | | | |
|
|
|
11.
|
What do the
image handles on a selected chart allow you to do? a. | Change the color of the
chart. | c. | Change the size of the
chart. | b. | Change the type of chart. | d. | Change the axes of the chart. | | | | |
|
|
|
12.
|
To change
the border and color of the plot area click the Patterns tab in the ____ dialog box. a. | Format Data
Series | c. | Format Axis
| b. | Format Chart
Area | d. | Format Plot
Area | | | | |
|
Completion
Complete each sentence or
statement.
|
|
|
13.
|
A(n)
____________________ chart appears directly on the spreadsheet rather than on a separate
sheet.
|
|
|
14.
|
____________________ are lines in a chart that relate the data to the
axes.
|
|
|
15.
|
A(n)
____________________ is a list that identifies patterns or symbols used in a chart.
|
|
|
16.
|
As a
default, Excel will name a chart saved on a sheet as ____________________.
|
|
|
17.
|
The Chart
____________________ helps you to create a chart from worksheet data.
|
|
|
18.
|
A graphical
representation of data contained in a worksheet is referred to as a(n)
____________________.
|
|
|
19.
|
A(n)
____________________ chart is ideal for illustrating trends over time.
|
|
|
20.
|
Lines that
establish a relationship between data in a chart are known as ____________________.
|
|
|
21.
|
The
____________________ menu contains the Zoom command.
|
|
|
22.
|
When
printing a chart sheet, you can click the ____________________ button on the toolbar or select Print
from the File menu.
|
|
|
23.
|
The
____________________ button on the toolbar is represented by a sheet of paper and a magnifying
glass.
|
|
|
24.
|
The small
black squares that appear at the corners and sides of a selected chart are called image
____________________.
|
|
|
25.
|
If you
wanted to add or change the data labels on a chart, you would open the Format ____________________
dialog box.
|
Matching
|
|
|
Match the
following chart names with its description below. a. | column | d. | scatter | b. | line | e. | XY | c. | pie | | | | |
|
|
|
26.
|
uses points
on a grid
|
|
|
27.
|
uses
rectangles of varying heights to illustrate the values in a worksheet
|
|
|
28.
|
another name
for a scatter chart
|
|
|
29.
|
uses
segments connected by points to illustrate the values in a worksheet
|
|
|
30.
|
shows the
relationship of parts to a whole
|