Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
1.
|
On the Ribbon each __________ surrounds a collection of groups.
a. | cluster | c. | aggregate | b. | tab | d. | mode |
|
|
|
2.
|
The __________ toolbar, which appears automatically based on tasks you perform
(such as
selecting text), contains commands related to changing the appearance of text in a
worksheet.
a. | Quick | c. | Mini | b. | Short | d. | Long |
|
|
|
3.
|
A(n) __________ is a list of additional commands associated with the selected
command.
a. | Alt command | c. | call-out | b. | submenu | d. | Quick command |
|
|
|
4.
|
In Excel, any set of characters containing a letter, hyphen (as in a telephone
number), or
space is considered __________.
a. | text | c. | empty | b. | numeric | d. | incorrect |
|
|
|
5.
|
If you prefer using the keyboard, instead of the mouse, you can press the ALT
key on
the keyboard to display a(n) __________.
a. | Keyboard picture | c. | Image mouse | b. | Key Tip badge | d. | Mouse image
badge |
|
|
|
6.
|
When a cell entry is positioned at the far left in the cell, it is considered
__________.
a. | left- and right-aligned | c. | left-aligned | b. | center-aligned | d. | right-aligned |
|
|
|
7.
|
In Excel, a number can contain the characters __________.
a. | 0 1 2 3 4 5 6 7 8 9 | c. | . $ % E e | b. | + - ( ) , / | d. | all of the
above |
|
|
|
8.
|
To enter a number such as 6,000,000,000,000,000 you can type
6,000,000,000,000,000 or
you can type __________.
a. | 6,000T | c. | 6Q | b. | 6K000 | d. | 6E15 |
|
|
|
9.
|
A __________ is a series of two or more adjacent cells in a column or row or a
rectangular group of cells.
a. | range | c. | nearby cell | b. | bunch | d. | neighbor |
|
|
|
10.
|
The cell being copied is called the source area (or copy area). The range of
cells receiving the copy is called the __________.
a. | receiver cell | c. | receiving range | b. | final cell | d. | destination area (or paste
area) |
|
|
|
11.
|
Every time you enter a value into a cell in the worksheet, Excel automatically
____ formulas.
a. | recalculates new | c. | recalculates old | b. | recalculates some | d. | recalculates
all |
|
|
|
12.
|
When an error occurs in a formula in a cell, Excel displays the ____ button next
to the cell and identifies the cell with the error by placing a green triangle in the upper left of
the cell.
a. | Smart Tag Actions | c. | Trace Error | b. | AutoCorrect Options | d. | Auto Fill
Options |
|
|
|
13.
|
The ____ button lists formatting options following an insertion of cells, row,
or columns.
a. | Paste Options | c. | Auto Fill Options | b. | Insert Options | d. | AutoCorrect
Options |
|
|
|
14.
|
In Excel, functions can be entered using any of the following methods
except the ____.
a. | Function command on the Tools menu | c. | Insert Function box in the formula
bar | b. | keyboard or mouse | d. | AutoSum command on the Formulas tab |
|
|
|
15.
|
How do you activate Range Finder to verify a formula in a cell?
a. | Range Finder does not verify formulas | c. | Double-click in the
cell | b. | Press the ESC key | d. | Click the Range Finder button |
|
|
|
16.
|
Using the ____ button on the Ribbon instructs Excel to display additional
decimal places in a cell.
a. | AutoFormat | c. | Increase Decimal | b. | Currency Style | d. | Percent Style |
|
|
|
17.
|
Click ____ in the Conditional Formatting gallery to display the New Formatting
Rule dialog box.
a. | Rule Format | c. | New Format | b. | New Rule | d. | Format Rule |
|
|
|
18.
|
When Excel starts and the blank worksheet displays on the screen, all of the
columns have a default width of ____.
|