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
Q90: When a(n)_ function is nested in the
Q91: Advantages of using the _ function instead
Q92: A conditional _ function can calculate on
Q93: The _ function expands on the AVERAGEIF
Q94: If letters appear for the column headings,the
Q95: The _ function sums data and allows
Q96: _ is code that uses the structure
Q97: A(n)_ function is used to look up
Q98: Match the following terms to their description.
Q99: Match the following terms to their description.
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents