Match the Following Five Terms to Their Meanings

Multiple Choice

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.