Multiple Choice
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
Correct Answer:

Verified
Correct Answer:
Verified
Q40: By default,AutoFill copies only the content not
Q41: Susan is in charge of the inventory
Q42: The _ category of Excel functions returns
Q43: A <span class="ql-formula" data-value="\underline {
Q44: The Insert Function button is in the
Q46: An _ occurs when the lookup value
Q47: Not all functions have arguments,and some functions
Q48: If an optional argument is not included,Excel
Q49: Absolute references are marked with a _.<br>A)<<br>B):<br>C)$<br>D)!
Q50: The Insert Function dialog box has a(n)_