WorksheetsExcel 2016 MOAC Lesson 04
Total questions: 10
Worksheet time: 6mins
Which of the following is not an arithmetic operator?
+
-
*
]
Per the order of operations, what is the answer to this formula: =2*(2+2)?
6
8
4
2
Per the order of operations, what is the answer to this formula: =2*2+2?
6
8
4
2
Which of the following is an example of an absolute cell reference?
A9
A$9
$A$9
A9:E9
Which of the following is an example of a relative cell reference?
A9
A$9
$A$9
A9:E9
To allow Excel to distinguish formulas from data, all formulas begin with an equal sign (=).
TRUE
FALSE
It is always best to use the exact value instead of the cell reference when using formulas.
TRUE
FALSE
You can press the F4 key to add the $'s to an absolute reference.
TRUE
FALSE
The order of operations determines which parts of a formula are calculated before other parts of the formula.
TRUE
FALSE
The formula = 6 * 2 + 3 produces the same result as = 6 * (2 + 3).
TRUE
FALSE
