Matching
Match the following terms with the corresponding description:
Premises:
SUMIF
AVERAGEIF
COUNTIF
SUMIFS
AVERAGEIFS
Responses:
Finds the mean for the cells specified by 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 set of conditions or criteria.
Counts the number of cells within a range that meet the given condition.
Adds the cells specified by on a given condition or criteria
Correct Answer:
Premises:
Responses:
SUMIF
AVERAGEIF
COUNTIF
SUMIFS
AVERAGEIFS
Premises:
SUMIF
AVERAGEIF
COUNTIF
SUMIFS
AVERAGEIFS
Responses:
Related Questions
Q71: When using the QUARTILE.INC function the 4th
Q72: The _ function calculates the variance of
Q73: Histograms can be created on a separate
Q74: Which of the following functions is best
Q75: Match the following terms with the corresponding
Q77: Histogram is a tool of the Analysis
Q79: What is the difference between calculating standard
Q80: When using an array of data with
Q81: The _ function determines how often a
Q93: _ is a statistical hypothesis test that