True/False
Indicate whether the sentence or statement is true
or false.
|
|
|
1.
|
The
delayed calculation feature of Excel improves the accuracy of calculations made in the worksheet by
slowing the computer speed.
|
|
|
2.
|
The
AutoSum feature may be used to add a long column of numbers.
|
|
|
3.
|
The
AutoCalculation feature of Excel may be used to determine the sum of a group of numbers without
inserting a formula into the worksheet.
|
|
|
4.
|
You
may display formulas in the worksheet rather than displaying formula results.
|
|
|
5.
|
The
plus sign (+) is an example of an operand in a worksheet formula.
|
|
|
6.
|
Once
you have keyed a formula, you can enter it by clicking on the dollar sign ($) on the formula
bar.
|
|
|
7.
|
In a
formula containing a relative cell reference, the operators stay the same, but the cell references
change when the formula is copied.
|
|
|
8.
|
With
the point-and-click method of cell referencing, you click the cell instead of keying a cell
reference.
|
|
|
9.
|
When
you choose to display formulas in cells instead of values, those cells that do not contain formulas
display an error message.
|
|
|
10.
|
You
can change the type of calculation using options on the Edit tab of the Options dialog
box.
|
Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
11.
|
Which
operation will be performed first in a formula that does not contain parentheses? a. | addition | c. | multiplication | b. | exponentiation | d. | subtraction | | | | |
|
|
|
12.
|
Which
type of cell reference does not change when it is moved or copied to a new cell? a. | absolute | c. | relative | b. | mixed | d. | stable | | | | |
|
|
|
13.
|
Which
type of cell reference adjusts to its new location when copied or moved? a. | absolute | c. | relative | b. | adapted | d. | stable | | | | |
|
|
|
14.
|
Suppose that the value in B3 is equal to 3 and the value in C3 is 4. Which of the
following formulas would display the value of 24? a. | =B3*C3+4 | c. | =B3*(C3+4) | b. | =(B3*C3)+4 | d. | =(B3*C3+4) | | | | |
|
|
|
15.
|
Suppose that the value in B3 is equal to 12 and the value in C3 is 3. Which of the
following formulas would display the value of 3? a. | =B3/C3+1 | c. | =B3/(C3+1) | b. | =(B3/C3)+1 | d. | =(B3/C3+1) | | | | |
|
|
|
16.
|
Which
operator represents exponentiation?
|
|
|
17.
|
What
type of cell reference contains both relative and absolute references? a. | mixed | c. | dual | b. | combination | d. | double | | | | |
|
|
|
18.
|
The
____ function is the most frequently used type of function formula.
|
|
|
19.
|
Which
menu contains the command to open the Options dialog box in which you can define features, including
those applied to formulas? a. | Window | c. | View | b. | Format | d. | Tools | | | | |
|
|
|
20.
|
Which
of the following do you press to switch between displaying formulas and displaying
values? a. | Ctrl+> | c. | Ctrl+` | b. | Shift+# | d. | Shift+* | | | | |
|
|
|
21.
|
The
____ sign in Excel represents the action exponentiation.
|
Completion
Complete each sentence or
statement.
|
|
|
22.
|
The
order of ____________________ is the sequence used to calculate the value of a formula.
|
|
|
23.
|
To
create an absolute cell reference, you need to insert a(n) ____________________ before the column
letter and/or the row number of the cell reference you want to stay the same.
|
|
|
24.
|
The
Greek letter sigma identifies the ____________________ button on the toolbar.
|
|
|
25.
|
You
can switch between viewing formulas and values by pressing the ____________________ key plus the `
key.
|
|
|
26.
|
A(n)
____________________ calculation is also known as a manual calculation.
|
|
|
27.
|
The
equations used to calculate values in a cell are known as _____________________.
|
|
|
28.
|
A(n)
____________________ is a number or cell reference used in formulas.
|
|
|
29.
|
A(n)
____________________ tells Excel what to do with operands.
|
|
|
30.
|
The
symbol * represents the action ____________________ in a formula.
|