Solved

Match the Following Terms with the Corresponding Description

Question 7

Matching

Match the following terms with the corresponding description:

Premises:
SUMIFS
COUNTIF
AVERAGEIF
AVERAGEIFS
SUMIF
Responses:
Adds the cells specified by on a given condition or criteria
Adds the cells specified by a given set of conditions or criteria
Finds the mean for the cells specified by a given condition or criteria
Finds the mean for the cells specified by a given set of conditions or criteria.
Counts the number of cells within a range that meet the given condition.

Correct Answer:

SUMIFS
COUNTIF
AVERAGEIF
AVERAGEIFS
SUMIF
Related Questions

Q8: Match the following terms with the corresponding

Q23: Which of the following functions does not

Q33: The _ is the range of cells

Q39: What is the difference between COVARIANCE and

Q46: The _ is a predefined set of

Q47: The _ function determines the strength of

Q81: The _ function determines how often a

Q85: The _ function can be used to

Q93: _ is a statistical hypothesis test that

Q101: The _ function returns the gamma value