True/False
Indicate whether the sentence or statement is true
or false.
|
|
|
1.
|
Sheets are given the default names of Worksheet1,
Worksheet2, and Worksheet3.
|
|
|
2.
|
The
number of worksheets in a workbook can be changed.
|
|
|
3.
|
Headers, footers, and print orientation must be the same for each sheet in a
workbook.
|
|
|
4.
|
A pie
chart can include only one series of data.
|
|
|
5.
|
A
chart that appears as an object in a worksheet is printed when the worksheet is
printed.
|
|
|
6.
|
If a
value in a chart data series is changed, the chart automatically reflects the new data.
|
Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
7.
|
A
sheet is made active by a. | selecting the sheet name in the Windows
menu. | b. | clicking the appropriate tab at the bottom of the Excel
window. | c. | clicking the Name box until it displays the appropriate
sheet. | d. | pressing the Home button. | | |
|
|
|
8.
|
A
sheet can be renamed by a. | double-clicking its tab to select it, typing a new name, and
then pressing Enter. | b. | displaying the sheet and then selecting the Name
command. | c. | double-clicking its tab and selecting the Rename
command. | d. | selecting a name from the list of names in the Windows
menu. | | |
|
|
|
9.
|
Sheet
order can be changed by a. | typing the order in the Order dialog
box. | b. | dragging a sheet
tab to a new location. | c. | right-clicking a sheet tab and typing a new number for the
sheet. | d. | using the Cut and Paste buttons on the
toolbar. | | |
|
|
|
10.
|
Which
type of chart is best for charting data that is a percentage of a whole?
|
|
|
11.
|
Which
type of chart is best for comparing the differences between values?
|
|
|
12.
|
Which
type of chart is best for displaying the differences of data over time?
|
|
|
13.
|
The
portion of the worksheet to be charted is called the a. | slice. | b. | data range. | c. | Chart
Wizard. | d. | legend. | | |
|
|
|
14.
|
A
chart is sized proportionately by dragging a. | the middle right handle. | b. | a corner
handle. | c. | the middle left handle. | d. | the top middle
handle. | | |
|
|
|
15.
|
A
selected chart can be deleted by a. | selecting the Delete button on the Chart
toolbar. | b. | double-clicking a handle. | c. | pressing the
Delete key. | d. | pressing the Backspace key. | | |
|
|
|
16.
|
What
is printed if a chart that appears as an object in a worksheet is selected and then the Print
command is selected? a. | all the sheets and charts in the
workbook | b. | only the chart on a single sheet of paper in landscape
orientation | c. | only the chart on a single sheet of paper in portrait
orientation | d. | the worksheet and the chart | | |
|
|
|
17.
|
The
first step in creating a bar or line chart is a. | selecting a location for the chart. | b. | selecting the
data to be charted. | c. | selecting the chart type. | d. | verifying the
source data. | | |
|
Matching
|
|
|
Match the letter with the corresponding part of the worksheet or
chart.
|
|
|
18.
|
chart
title
|
|
|
19.
|
legend
|
|
|
20.
|
data
series
|
|
|
21.
|
data
label
|
|
|
22.
|
slice
|