True/False
Indicate whether the sentence or statement is true
or false.
|
|
|
1.
|
Data
that is copied is stored on the Clipboard until it is pasted or until you copy something
else.
|
|
|
2.
|
Moving data on a worksheet does not remove the data from its original
location.
|
|
|
3.
|
When
inserting a row into a worksheet, the inserted row appears below the highlight.
|
|
|
4.
|
In
order to freeze a title row, place the highlight above the row you want to freeze.
|
|
|
5.
|
The
Sheet tab in the Page Setup dialog box contains options for setting the print area, and printing
gridlines, row headings, and column headings.
|
|
|
6.
|
Excel
contains a spell checking tool.
|
|
|
7.
|
Fill
Right and Fill Left copies data into the cell(s) to the right or left of the original
cell.
|
|
|
8.
|
To
unfreeze a row or column title, choose the Split Panes command on the Window menu.
|
|
|
9.
|
You
cannot manually set page breaks in a worksheet.
|
Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
10.
|
The
Page Setup dialog box has four tabbed sections. Under which tab do you designate whether the page
will be printed in portrait or landscape? a. | Page | c. | Header/Footer | b. | Margins | d. | Sheet | | | | |
|
|
|
11.
|
The
Page Setup dialog box has four tabbed sections. Under which tab do you designate the title of the
worksheet? a. | Page | c. | Header/Footer | b. | Margins | d. | Sheet | | | | |
|
|
|
12.
|
What
happens if data are copied in cells that have existing data? a. | An error message
will appear. | b. | The old data will be placed on the
Clipboard. | c. | The new data will not be copied. | d. | The old data
will be replaced by the new data. | | |
|
|
|
13.
|
Which
of the following is not a method for copying data to another part of the
worksheet? a. | Drag-and-Drop | c. | Inserting | b. | Fill Down | d. | Copy and Paste | | | | |
|
|
|
14.
|
Data
stored on the ____ will remain until it is replaced with new data. a. | worksheet | c. | Clipboard | b. | toolbar | d. | border | | | | |
|
|
|
15.
|
The
drag-and-drop method is the same for moving data as it is for copying data except you do not hold
down the ____ key. a. | Shift | c. | Alt | b. | Ctrl | d. | Insert | | | | |
|
|
|
16.
|
To
add a cell, row, or column to a worksheet, you should use commands on the ____ menu. a. | Edit | c. | File | b. | View | d. | Insert | | | | |
|
|
|
17.
|
Frozen rows are indicated by a darkened ____ that separates the frozen and unfrozen
areas. a. | column | c. | row | b. | gridline | d. | title bar | | | | |
|
|
|
18.
|
The
____ tab in the Page Setup dialog box allows you to add or remove gridlines from your printed
worksheet. a. | Page | c. | Header/Footer | b. | Margins | d. | Sheet | | | | |
|
Completion
Complete each sentence or
statement.
|
|
|
19.
|
A(n)
____________________ border appears around the selection when you copy it.
|
|
|
20.
|
The
____________________ command removes data from its original place on the worksheet and places it on
the Clipboard.
|
|
|
21.
|
The
Delete command can be found on the ____________________ menu.
|
|
|
22.
|
To
unfreeze a row or column title, choose the Unfreeze Panes command on the ____________________
menu.
|
|
|
23.
|
The
____________________ tab in the Page Setup dialog box contains the page orientation
options.
|
|
|
24.
|
____________________ copies data into adjacent cells.
|
|
|
25.
|
The
_____________________ method is the easiest way to move data in a worksheet.
|
Matching
|
|
|
Match the following worksheet problems with the operation below that will address
them. a. | You need to copy
data from one cell to several other cells. | b. | You would like to view the top row on the worksheet even when
scrolling down several screens. | c. | You would like to place a range of data in a different part of
the worksheet. | d. | You would like to add a blank column between two columns that
already contain data. | | |
|
|
|
26.
|
Paste
|
|
|
27.
|
Fill
|
|
|
28.
|
Insert
|
|
|
29.
|
Move
|
|
|
30.
|
Freeze Panes
|