Matching
Match each of the following functions to its best description of its purpose:
Premises:
COUNTIFS
AVERAGEIF
SUMIF
SUMIFS
COUNTIF
Responses:
Calculates the total of a range of values when a specified condition is met
Calculates the total value of cells in a range that meet multiple criteria
Calculates the average, or arithmetic mean, of all cells in a range that meet a specific condition
Returns the number of cells in a range that meet multiple criteria
Calculates the number of cells in a range when a specified condition is met
Correct Answer:
Premises:
Responses:
COUNTIFS
AVERAGEIF
SUMIF
SUMIFS
COUNTIF
Premises:
COUNTIFS
AVERAGEIF
SUMIF
SUMIFS
COUNTIF
Responses:
Related Questions
Q40: _ is a measure of how two
Q41: The VARPA function calculates the variance of
Q42: A(n)_ is a visual display of tabulated
Q43: If you autofill the formula =RANK.AVG(A1,$A$1:$A$5,0)from B1
Q44: The _ function counts the number of
Q46: Which function would you use to determine
Q47: Which of the following represents the number
Q48: A histogram requires _ to tabulate data
Q49: What is the common name for the
Q50: What function returns the variance of a