Multiple Choice
The syntax of the AVERAGEIF function ____ is very similar to the syntax of the SUMIF function.
A) (range,criteria,average_range)
B) (criteria,average,range)
C) (ref,range,criteria)
D) (array,average_range,ref)
Correct Answer:

Verified
Correct Answer:
Verified
Q76: The statistical function MODE returns the most
Q77: With the COUNTIF function, the first time
Q78: A format code can include up to
Q79: The Format Cells dialog box, which can
Q80: Case-Based Critical Thinking Questions<br>Case 2-1<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg"
Q82: When working with the RAND and RANDBETWEEN
Q83: If you wrote the formula =ODD(1.23), the
Q84: The _ symbol indicates to skip the
Q85: With the LARGE function, the argument called
Q86: MATCHING<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg" alt="MATCHING