Matching
Match each of the following concepts to its best description:
Premises:
AVERAGEIFS
Criteria2
Criteria
Criteria_range1
Sum_range
Responses:
The range of values to be added together in conditional math functions
The function which returns the average of a given range of values which matches multiple criteria
The second criteria in a function matching multiple criteria.
The value to be matched in a conditional math function
The location of a criteria to be met in a function matching multiple criteria
Correct Answer:
Premises:
Responses:
Criteria2
The second criteria in a function matching multiple criteria.
Sum_range
The range of values to be added together in conditional math functions
Criteria
The value to be matched in a conditional math function
AVERAGEIFS
The function which returns the average of a given range of values which matches multiple criteria
Criteria_range1
The location of a criteria to be met in a function matching multiple criteria
Premises:
Criteria2
Sum_range
Criteria
AVERAGEIFS
Criteria_range1
Responses:
The second criteria in a function matching multiple criteria.
The range of values to be added together in conditional math functions
The value to be matched in a conditional math function
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
Related Questions
Q2: Which of the following functions determines the
Q3: Which of the following is not an
Q4: Match each of the following concepts to
Q5: In SUMIF, AVERAGEIF, and COUNTIF functions using
Q6: The _ function calculates the average, or
Q7: Correlation is a tool included on the
Q8: The _ is the probability of a
Q9: The _ function returns the variance of
Q10: Match each of the following concepts to
Q11: ANOVA stands for analysis of variability.