True/False
Indicate whether the sentence or statement is true
or false.
|
|
|
1.
|
You
may print an entire workbook or selected worksheets, but not selected areas of a
workbook.
|
|
|
2.
|
Worksheets may be identified in a workbook by changing the worksheet
name.
|
|
|
3.
|
Worksheets may be identified by changing the color of the worksheet tab.
|
|
|
4.
|
Three-dimensional references are used to include data from other worksheets in a
formula.
|
|
|
5.
|
Worksheets may be added to and deleted from a workbook.
|
|
|
6.
|
More
than one worksheet of a workbook may be viewed on screen by selecting Split from the View
menu.
|
|
|
7.
|
The position
of a worksheet may be changed by dragging the tab at the bottom of the workbook.
|
|
|
8.
|
You
may hide a worksheet in a workbook.
|
|
|
9.
|
To delete a
worksheet, select the worksheet and then click Delete Sheet on the Edit menu.
|
|
|
10.
|
Additional
worksheets can be made active by holding down the Ctrl key while clicking the worksheet
tab.
|
|
|
11.
|
A new
worksheet will be inserted after the sheet you have selected.
|
|
|
12.
|
Moving a worksheet between other sheets can affect 3-dimensional references in a
workbook.
|
|
|
13.
|
You
can place a background pattern in a worksheet.
|
|
|
14.
|
The
sheet that appears on the screen is referred to as the active sheet.
|
|
|
15.
|
To
change the name of a worksheet, click the sheet tab, and then key the name you would like to identify
the worksheet.
|
Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
16.
|
What
is the most logical operation for summarizing data contained on several worksheets in a
workbook? a. | inserting | c. | referencing | b. | linking | d. | tabbing | | | | |
|
|
|
17.
|
What
item should be selected in the Print dialog box to print portions of more than one
worksheet? a. | active
sheet | c. | entire
workbook | b. | selection | d. | worksheet | | | | |
|
|
|
18.
|
Additional
worksheets can be made active by a. | holding down the Alt key while clicking the worksheet
tab. | b. | holding down the Ctrl
key while clicking the worksheet tab. | c. | right-clicking the worksheet tab. | d. | right-clicking
the worksheet tab and clicking Make Active on the submenu. | | |
|
|
|
19.
|
To
delete a worksheet a. | select the worksheet and then click Delete Sheet on the Edit
menu. | b. | right-click on
any tab and select Insert or Delete on the shortcut menu. | c. | either a or
b. | d. | neither a nor
b. | | |
|
|
|
20.
|
In a
three-dimensional reference, the sheet name and cell reference are separated by which of the
following?
|
Matching
|
|
|
Match the following terms with the definitions below. a. | active
worksheet | d. | three-dimensional reference | b. | worksheet tab | e. | workbook | c. | link | | | | |
|
|
|
21.
|
formula references that incorporate data from other worksheets
|
|
|
22.
|
a
collection of worksheets
|
|
|
23.
|
identifies worksheets within a workbook a the bottom of a workbook
window
|
|
|
24.
|
sheet
of a workbook that currently appears on the screen
|
|
|
25.
|
transfers data from one worksheet to another
|
|
|
Match the following formulas with worksheet formula results
below. a. | =Sheet5!A4 | d. | =SUM(Sheet5!A4:A5) | b. | =Sheet4!A4+Sheet5!A5 | e. | =Sheet4!A5+Sheet5!A4 | c. | =SUM(Sheet4:Sheet6!A4) | | | | |
|
|
|
26.
|
Adds the
values in A4 on Sheet4, Sheet5, and Sheet6.
|
|
|
27.
|
Inserts the
value contained in A4 from the sheet named Sheet5.
|
|
|
28.
|
Adds the
values in A4 and A5 of Sheet5.
|
|
|
29.
|
Adds the
values in A4 of the sheet named Sheet4 and A5 of the sheet named Sheet5.
|
|
|
30.
|
Adds the
values in A5 of the sheet named Sheet4 and A4 of the sheet named Sheet5.
|