Matching
Match the following terms to their description.
Premises:
Conditional aggregate function
IFERROR function
Conjunction function
Nested IF
Conditional statistical function
Responses:
A function that uses IF functions as arguments within another IF function
A function that allows evaluation of multiple logical tests and enables linking or joining of functions or formulas
A function that consolidates or summarizes a subset of data that has been filtered based upon one or more criteria
A function that calculates on a subset of data that meets specified criteria
A function that evaluates if an error occurs and replaces an error message with a user supplied error message
Correct Answer:
Premises:
Responses:
Conditional aggregate function
IFERROR function
Conjunction function
Nested IF
Conditional statistical function
Premises:
Conditional aggregate function
IFERROR function
Conjunction function
Nested IF
Conditional statistical function
Responses:
Related Questions
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
Q41: All of the following statements are TRUE
Q42: The IF function provides two outcomes,one when
Q44: The _ function returns the value of
Q45: The INDIRECT function is valuable because it
Q46: A _ IF function uses IF functions
Q47: The first argument of the AVERAGEIF function
Q48: The _ argument of the COUNTIF function