Matching
Match each of the following concepts to its best description:
Premises:
Criteria2
Sum_range
Criteria
Criteria_range1
AVERAGEIFS
Responses:
The function which returns the average of a given range of values which matches multiple criteria
The location of a criteria to be met in a function matching multiple criteria
The second criteria in a function matching multiple criteria.
The value to be matched in a conditional math function
The range of values to be added together in conditional math functions
Correct Answer:
Premises:
Responses:
Criteria2
Sum_range
Criteria
Criteria_range1
AVERAGEIFS
Premises:
Criteria2
Sum_range
Criteria
Criteria_range1
AVERAGEIFS
Responses:
Related Questions
Q8: The _ is the probability of a
Q11: Match each of the following concepts to
Q29: Which of the following is an Excel
Q30: A college admissions office might use which
Q41: The VARPA function calculates the variance of
Q63: The Greek letter mu is the symbol
Q72: This formula will successfully count all green
Q74: Which function would you use to test
Q78: A histogram is a pie chart created
Q91: The Significance argument in a PERCENTRANK function