Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
1.
|
Information created in Excel is saved in a file called a
a. | worksheet. | b. | database. | c. | workbook. | d. | datasheet. |
|
|
|
2.
|
In an Excel worksheet, columns are referenced with ____, while rows are
referenced with ____.
a. | letters; numbers | b. | uppercase letters; lowercase
letters | c. | lowercase letters; uppercase letters | d. | numbers;
letters |
|
|
|
3.
|
This part of the Excel screen displays the contents of the active cell.
a. | Name text box | b. | Formula bar | c. | Title
bar | d. | Status bar |
|
|
|
4.
|
By default, Excel 2007 workbooks are saved with the ____ extension.
a. | .dotx | b. | .pptx | c. | .docx | d. | .xlsx |
|
|
|
5.
|
What is the black square at the bottom right corner of an active cell?
a. | fill handle | b. | cell pointer | c. | sizing
handle | d. | Auto Fill options button |
|
|
|
6.
|
All formulas in Excel begin with
a. | a cell reference. | b. | an apostrophe (‘). | c. | the equals sign
(=). | d. | a number. |
|
|
|
7.
|
Excel features built-in, preprogrammed formulas called
a. | functions. | b. | operators. | c. | exponentiations. | d. | wizards. |
|
|
|
8.
|
Which of the following examples makes use of a range?
a. | =SUM(D2:R2) | b. | AZ102 | c. | =A1+B1 | d. | =B6+C6 |
|
|
|
9.
|
Excel’s Accounting number format adds ____ to the value in the
cell.
a. | a dollar sign | b. | a comma in the thousands
place | c. | two decimal places | d. | All of the
above |
|
|
|
10.
|
What picture appears on the Microsoft Office Excel Help button near the upper
right corner of the screen?
a. | a question mark (?) | b. | an exclamation point (!) | c. | a light
bulb | d. | an X |
|
|
|
11.
|
This keyboard shortcut opens the Print dialog box.
a. | Alt + P | b. | Ctrl + V | c. | Alt +
V | d. | Ctrl + P |
|
|
|
12.
|
This Excel feature can be used to replace a word in the worksheet with another
word of similar meaning.
a. | Spelling | b. | Translate | c. | Research | d. | Thesaurus |
|
|
|
13.
|
To select multiple rows or columns that are not adjacent, hold down the ____ key
while clicking.
|
|
|
14.
|
When copying or moving cells, if data already exists in the destination cells,
Excel
a. | adds the new content to the existing content. | b. | moves the existing
content to the nearest blank cell. | c. | will not complete the copy or move
procedure. | d. | replaces the contents. |
|
|
|
15.
|
When you hold down the Ctrl key and drag a selected ranges of cells, a ____
attached to the pointer indicates that the source contents are being ____.
a. | check mark; spell-checked | b. | plus sign; copied | c. | minus sign;
erased | d. | four-headed arrow; moved |
|
|
|
16.
|
This option in the Paste button converts rows to columns and columns to rows for
the pasted cells.
a. | Paste Special | b. | Transpose | c. | Paste
Values | d. | Formulas |
|
|
|
17.
|
This action sets the width of a column to fit the longest entry in the
column.
a. | clicking the column indicator | b. | right-clicking in the cell containing the
longest entry | c. | double-clicking the boundary line | d. | double-clicking in the cell containing the
longest entry |
|
|
|
18.
|
When you change the color of the fill in a cell, you are changing its
a. | border. | b. | background. | c. | text. | d. | All of the
above |
|
|
|
19.
|
What does the Format Painter feature do?
a. | applies a built-in style to a cell | b. | resets the format of a cell to the default
values | c. | displays a palette of color and font choices with which you can format a
cell | d. | copies formats from a selected cell to another cell |
|
|
|
20.
|
To hide a column in Excel, begin by selecting the column, and then
a. | press the Delete key. | b. | click the Clear button. | c. | right-click in the
area to display the shortcut menu. | d. | press Ctrl + H. |
|
|
|
21.
|
What does Excel’s Freeze Panes option do?
a. | locks the display of your worksheet so that no scrolling is
permitted | b. | splits the screen so that you can view two different workbooks at
once | c. | causes the specified rows and columns to remain fixed while
scrolling | d. | splits the screen so that you can view two different areas of your worksheet at
once |
|
|
|
22.
|
The keyboard shortcut for cutting the selection and placing it on the Clipboard
is
a. | Ctrl + C. | b. | Shift + Enter. | c. | Alt +
F1. | d. | Ctrl + X. |
|
|
|
23.
|
How does the AVERAGE function deal with empty cells and cells containing a zero
value?
a. | It uses the empty cells, but ignores the zero values in the
calculation. | b. | It uses both empty cells and zero values in the calculation. | c. | It ignores both
empty cells and zero values. | d. | It uses the zero values in the calculation, but
ignores the empty cells. |
|
|
|
24.
|
One of the arguments needed in the PMT function is pv. What does
pv stand for?
a. | present value | b. | past value | c. | present
volume | d. | payment volume |
|
|
|
25.
|
An IF function embedded within another IF function is referred to as a(n) ____
IF.
a. | double | b. | immediate | c. | nested | d. | bivariate |
|