Multiple Choice
The IF function
A) contains data for the basis of the lookup and data to be retrieved.
B) looks up a value and returns a related result from the lookup table.
C) evaluates a condition and returns one value if the condition is true and a different value if the condition is false.
D) contains another function embedded inside one or more of its arguments.
Correct Answer:

Verified
Correct Answer:
Verified
Q71: Excel displays a green arrow in the
Q72: _ references usually cause inaccurate results.
Q73: The _ function totals the values in
Q74: The V_ function looks up a value
Q75: The _ function displays the current date
Q77: The _ function finds the midpoint value
Q78: Excel displays a green arrow in the
Q79: If a formula contains a reference to
Q80: A mixed cell reference<br>A) occurs when a
Q81: The _ is the number of payments