Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
1.
|
The document
you produce when you use Excel is a ____. a. | Database | b. | Worksheet | c. | Slide show presentation | d. | Publication | | |
|
|
|
2.
|
The
intersection of a row and a column is called a ____. a. | Title | b. | Cell | c. | Formula | d. | Tab | | |
|
|
|
3.
|
A cell can
contain ____. a. | Numbers | b. | Text | c. | Formulas | d. | All the above | | |
|
|
|
4.
|
The area of
the worksheet window that displays the active cell address is called the ____. a. | Name
box | b. | Main menu
bar | c. | Formula
bar | d. | Toolbar | | |
|
|
|
5.
|
The cell you
are working in is called the ____. a. | Active cell | b. | Status cell | c. | Menu cell | d. | Worksheet cell | | |
|
|
|
6.
|
You can move
from sheet to sheet by clicking the ____. a. | Sheet tab scrolling buttons | b. | Sheet button
toolbar | c. | Status bar twice | d. | Name
box | | |
|
|
|
7.
|
Worksheet
data can be entered and edited in the ____. a. | Formula bar | b. | Sheet tab | c. | Menu bar | d. | Title bar | | |
|
|
|
8.
|
When a cell
contains both text and numbers, Excel recognizes the entry as a ____. a. | Value | b. | Label | c. | Formula | d. | Figure | | |
|
|
|
9.
|
Which of the
following methods can be used to navigate a worksheet? a. | Click the desired cell
address. | b. | Use the Go To command. | c. | Press the arrow keys
until the desired cell is active. | d. | All the above | | |
|
|
|
10.
|
When
creating a worksheet, enter the ____ first to establish the structure of the
worksheet. a. | Values | b. | Data | c. | Labels | d. | None of the above | | |
|
|
|
11.
|
Which of the
following values would be considered a complex formula? a. | =B3+C9*D12 | b. | =B3 | c. | =B3+C9 | d. | All of the above | | |
|
|
|
12.
|
Clicking the
Cancel button on the formula bar before accepting the cell entry allows you to ____. a. | Move forward one
cell | b. | Go to the end of the
workbook | c. | Keep the current contents of the cell | d. | Delete a
row | | |
|
|
|
13.
|
To put Excel
into Edit mode, select the cell you want to edit, then ____. a. | Click the formula
bar | b. | Double-click the
selected cell | c. | Press [F2] | d. | All of the above | | |
|
|
|
14.
|
To select a
range of cells, click the first cell and ____ to the last cell you want to include. a. | Paste | b. | Drag | c. | Copy | d. | None of the above | | |
|
|
|
15.
|
B6:C6 is an
example of a(n) ____. a. | Label | b. | Insertion point | c. | Range | d. | Formula | | |
|
|
|
16.
|
All Excel
formulas begin with ____.
|
|
|
17.
|
The correct
formula to multiply cell D5 by cell B2 is ____. a. | B2*D5 | b. | =D5*B2 | c. | D5*B2 | d. | (D5*B2) | | |
|
|
|
18.
|
In the
calculation =1200/23-600+75*45, which mathematical operation is performed first? a. | Subtraction | b. | Multiplication | c. | Division | d. | Addition | | |
|
|
|
19.
|
The order of
precedence in Excel formulas can be changed by using ____. a. | Quotation
marks | b. | Parentheses | c. | Colons | d. | Question marks | | |
|
|
|
20.
|
In the
calculation =8+.98/3500*9, which operation is performed first? a. | Division | b. | Multiplication | c. | Addition | d. | Subtraction | | |
|
|
|
21.
|
In the
calculation =8+.98/3500*9, which operation is performed second? a. | Division | b. | Multiplication | c. | Addition | d. | Subtraction | | |
|
|
|
22.
|
All Excel
functions begin with the ____ symbol.
|
|
|
23.
|
SUM and
AVERAGE are examples of ____. a. | Buttons | b. | Toggles | c. | Functions | d. | Arguments | | |
|
|
|
24.
|
$A$1 is an
example of a(n) ____. a. | Formula | b. | Absolute cell reference | c. | Calculation | d. | None of the above | | |
|
|
|
25.
|
Which method
can be used to copy information? a. | Copy and Paste buttons | b. | Drag-and-drop | c. | Both a and b | d. | All of the
above | | |
|