True/False
Indicate whether the sentence or statement is true
or false.
|
|
|
1.
|
The
primary purpose of a spreadsheet program like Excel is to solve problems that involve
numbers.
|
|
|
2.
|
The
formula bar appears directly above the toolbar in the worksheet.
|
|
|
3.
|
If
you want to move the cursor to cell A1 you should press Ctrl+Home on your keyboard.
|
|
|
4.
|
Worksheet cells only contain text.
|
|
|
5.
|
In
order to replace the contents of a cell you must first select the cell and then key in the new
data.
|
|
|
6.
|
The
Save command will update the latest version of your open file.
|
|
|
7.
|
You
cannot change the default settings for printing a worksheet.
|
|
|
8.
|
You
can choose to print all or part of a worksheet.
|
Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
9.
|
In
Excel, a collection of worksheets is referred to as a a. | spreadsheet. | c. | notebook. | b. | work area. | d. | workbook. | | | | |
|
|
|
10.
|
The
intersection of a worksheet column and row is a a. | cell. | c. | highlight. | b. | range. | d. | name
box. | | | | |
|
|
|
11.
|
A
group of cells that touch each other and form a rectangle are a a. | cell. | c. | highlight. | b. | range. | d. | name box. | | | | |
|
|
|
12.
|
Which
of the following will clear data from a highlighted cell? a. | pressing the
Delete key | c. | choosing Clear
from the Edit menu | b. | pressing the Backspace key | d. | all of the above | | | | |
|
|
|
13.
|
What
term describes a cell that is ready for data entry? a. | active
cell | c. | name
box | b. | cell
reference | d. | bordered
cell | | | | |
|
|
|
14.
|
Which
menu contains the Save As command? a. | File | c. | View | b. | Edit | d. | Window | | | | |
|
|
|
15.
|
When
Excel starts, a blank worksheet titled ____ appears on the screen. a. | Excel1 | c. | Book1 | b. | Worksheet1 | d. | Spreadsheet1 | | | | |
|
|
|
16.
|
To
move to the last cell containing data, you should press a. | Ctrl +
Home. | c. | Ctrl + Page
Up. | b. | Ctrl +
End. | d. | Ctrl + Down
Arrow. | | | | |
|
|
|
17.
|
Which
key would you press to remove data from the selected cell? a. | Ctrl | c. | Alt | b. | Shift + End | d. | Delete | | | | |
|
|
|
18.
|
To
edit data in a cell, select the cell and press the ____ key, referred to as the Edit
key.
|
Completion
Complete each sentence or
statement.
|
|
|
19.
|
A
collection of related worksheets is referred to as a(n) ____________________.
|
|
|
20.
|
A
cell is identified by the column letter and the row number, also known as the cell
____________________.
|
|
|
21.
|
The
fastest way to move the highlight to a cell that does not appear on the screen is by choosing
____________________ on the Edit menu.
|
|
|
22.
|
A(n)
____________________ is a selected group of cells.
|
|
|
23.
|
You
can use the Delete key, the ____________________ key, or choose Clear on the Edit menu to empty a
selected cell.
|
|
|
24.
|
The
first time you save a worksheet you will use the ____________________ dialog box.
|
|
|
25.
|
You
can print a file by choosing Print on the ____________________ menu.
|
Matching
|
|
|
Match the following commands with the operations below. a. | Choose Save from
the File menu | b. | Choose Go To from the Edit menu | c. | Choose Save As
from the File menu | d. | Choose Open from the File menu | e. | Choose Print
from the File menu | | |
|
|
|
26.
|
To
make a worksheet appear on screen
|
|
|
27.
|
To
save a workbook on a disk under its current name
|
|
|
28.
|
To
save a workbook on a disk under a new name
|
|
|
29.
|
To
move the highlight to a cell
|
|
|
30.
|
To
produce a paper copy of a worksheet
|