MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Indicate that some part of formula is preventing Excel from returning a calculated value.
A)NOW
B)error value
C)COUNTA
D)

Question

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Indicate that some part of formula is preventing Excel from returning a calculated value.
A)NOW
B)error value
C)COUNTA
D)<
E)MEDIAN
F)Mon, Tues, Wed, Thurs, Fri
G)F4
H)absolute
I)nested
J)mixed

Quizplus · Accepted Answer

Error values are displayed in Excel when there is an issue with the formula preventing it from returning a calculated value.

Answer: H
 An absolute reference in Excel allows a cell reference to remain constant in a formula when it is copied to other cells. This can help prevent errors in calculation.

Answer: D
 The less than symbol (<) can be used in formulas in Excel as a comparison operator to check if a value is less than another value. However, if used improperly it can also cause errors in calculation.

MATCHING Identify the Letter of the Choice That Best Matches the the Phrase