True/False
Indicate whether the
statement is true or false.
|
|
|
1.
|
In an Excel complex formula, addition and subtraction operators are calculated
before multiplication and division operators.
|
|
|
2.
|
An Excel formula can include more than one operation; for example,
multiplication and addition.
|
|
|
3.
|
Functions are organized into categories, such as Financial, Date & Time, and
Statistical, based on their purpose.
|
|
|
4.
|
To enter a function into a cell, you can manually type the function, including
its arguments, into the cell.
|
|
|
5.
|
When you click on a function in the AutoComplete list, a ScreenTip appears
describing the selected function.
|
|
|
6.
|
When you cut cells, the original data remains in the original location.
|
|
|
7.
|
Absolute cell references are the default in Excel.
|
|
|
8.
|
With each press of the [F1] key, you cycle through all the possible
combinations of relative, absolute, and mixed references.
|
|
|
9.
|
You can drag the fill handle in a cell to copy cells or to continue a series of
data based on previous cells.
|
Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
10.
|
Which of the following values would be considered a complex formula?
a. | =B3+C9*D12 | c. | =B3+C9 | b. | =B3 | d. | =B3*D12 |
|
|
|
11.
|
The formula =(20-8)/6 equals ____.
|
|
|
12.
|
The order of precedence in Excel formulas can be changed by using ____.
a. | quotation marks | c. | colons | b. | parentheses | d. | question marks |
|
|
|
13.
|
In the calculation =8+.98/3500*9-7, which operation is performed first?
a. | Division | c. | Addition | b. | Multiplication | d. | Subtraction |
|
|
|
14.
|
In the calculation =8+.98/3500*9-7, which operation is performed second?
a. | Division | c. | Addition | b. | Multiplication | d. | Subtraction |
|
|
|
|
|
|
15.
|
As shown in the figure above, item 2 points to the ____.
a. | Mode indicator | c. | ScreenTip | b. | Clipboard | d. | fill handle |
|
|
|
16.
|
The information in the parentheses in =MAX(A1:F5) is an example of a(n)
____.
a. | argument | c. | prefix | b. | function wizard | d. | template |
|
|
|
17.
|
Clicking the ____ button on the Function Arguments dialog box minimizes the
dialog box so you can select cells in the worksheet.
a. | Select | c. | Expand | b. | Minimize | d. | Collapse |
|
|
|
|
|
|
18.
|
As shown in the figure above, item 1 points to a(n) ____.
a. | function | c. | field | b. | argument | d. | variable |
|
|
|
19.
|
As shown in the figure above, item 2 points to the ____.
a. | Expand button | c. | Insert Function button | b. | Minimize
button | d. | Collapse
button |
|
|
|
|
|
|
20.
|
As shown in the figure above, the plus sign (+) in the cell pointed to by item 2
indicates ____.
a. | a fill handle | c. | dragging in progress | b. | the cell content being
copied | d. | copying in
progress |
|
|
|
21.
|
As shown in the figure above, item 3 points to the ____.
a. | cell being copied | c. | cell being dragged | b. | new location of copied
content | d. | cell on which the
fill handle is used |
|
|
|
|
|
|
22.
|
As shown in the figure above, item 1 points to the ____.
a. | Copy button | c. | Clipboard launcher | b. | Paste button | d. | Collapse button |
|
|
|
23.
|
As shown in the figure above, item 2 points to the ____.
a. | Copy button | c. | Clipboard launcher | b. | Paste button | d. | Collapse button |
|
|
|
24.
|
As shown in the figure above, item 3 points to the ____.
a. | Copy button | c. | Clipboard launcher | b. | Paste button | d. | Collapse button |
|
|
|
25.
|
The formula =SUM(A4:A13) contains ____ cell references.
a. | absolute | c. | mixed | b. | relative | d. | complex |
|
Matching
|
|
|
Identify the letter of the choice that best matches the phrase or
definition. a. | function | d. | relative cell
reference | b. | Office Clipboard | e. | template | c. | absolute cell
reference |
|
|
|
26.
|
A temporary storage area that holds the selections you copy or cut.
|
|
|
27.
|
A predesigned workbook file intended to save time when you create common
documents such as balance sheets, expense statements, loan amortizations, sales invoices, or
timecards.
|
|
|
28.
|
A predefined worksheet formula that enables you to perform complex calculations
easily.
|
|
|
29.
|
Changes based on the location when you copy the formula.
|
|
|
30.
|
Does not change when you copy the formula.
|