Solved

Match Each of the Following Functions to Its Best Description

Question 89

Matching

Match each of the following functions to its best description of its purpose:

Premises:
COUNTIF
SUMIFS
AVERAGEIF
COUNTIFS
SUMIF
Responses:
Calculates the number of cells in a range when a specified condition is met
Calculates the total of a range of values when a specified condition is met
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 total value of cells in a range that meet multiple criteria

Correct Answer:

COUNTIF
SUMIFS
AVERAGEIF
COUNTIFS
SUMIF
Related Questions

Q22: A quartile is a value used to

Q37: The arguments for COUNTIFS, SUMIFS, AVERAGEIFS are

Q39: The PERCENTRANK.INC function displays a value's rank

Q47: Which of the following represents the number

Q52: The _ function returns a value's rank

Q54: The _ function is best suited to

Q83: _ is the measure of how far

Q86: Sort data in _ order before beginning

Q88: Match each of the following concepts to

Q92: A(n)_ is a visual depiction of a