Multiple Choice
All of the following statements are TRUE about nested IF functions EXCEPT:
A) Each nested function needs a pair of parentheses.
B) Excel color codes parentheses to indicate which parentheses are paired.
C) Nested IF functions permit more than two outcomes.
D) The outcome of a nested IF function is limited to numeric or text values.
Correct Answer:

Verified
Correct Answer:
Verified
Q84: The ability to use MATCH and INDEX
Q85: All of the following statements are TRUE
Q86: Which of the following is the correct
Q87: The following function is an example of
Q88: A(n)_ is the strategic advantage that a
Q90: The COUNTIFS function allows for multiple criteria
Q91: If numbers appear for the column headings,the
Q92: A conditional _ function can calculate on
Q93: The VLOOKUP function is the more commonly
Q94: AND,OR,and NEVER are all examples of conjunction