Multiple Choice
All of the following statements are TRUE about the IF function EXCEPT:
A) The [value_if_false] argument may be omitted from the IF function.
B) The IF function is the most common logical function.
C) The TRUE argument of the IF function is optional.
D) Cell references listed in the IF function must be capitalized.
Correct Answer:

Verified
Correct Answer:
Verified
Q36: Which of the following is an example
Q37: A nested IF requires one or more
Q38: The function =IF(SUM(Trans_Qty)>E20,"Goal Met","Under Goal")is an example
Q39: All of the following statements are TRUE
Q40: Data that is manually calculated and typed
Q42: The IF function provides two outcomes,one when
Q43: Match the following terms to their description.
Q44: The _ function returns the value of
Q45: The INDIRECT function is valuable because it
Q46: A _ IF function uses IF functions