Match the following five terms to their meanings:
i.nested function
II.AND function
III.NOT function
IV.AVERAGEIFS function
v.OR function
A) This function returns a value of TRUE if ALL of the conditions are met.
B) A logical function that takes only one argument and is used to test one condition.
C) This function returns a value of TRUE if ANY of the conditions are met.
D) A function that is contained inside another function.
E) This function enables you to specify multiple criteria when computing an average.
Correct Answer:
Verified
Q81: Match the following five terms to their
Q82: Use Excel's _ Manager tool to compare
Q83: After creating several scenarios,you can create a
Q84: A _ is a set of values
Q85: Match the following five terms to their
Q87: _ functions,for example AND and NOT,test for
Q88: The _ function returns a value of
Q89: The _ function returns a value of
Q90: Solver is located in the _ group
Q91: Match the following four terms to their
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