Reviewer: CUT 1 - 3rd Term

A conditional function that adds all values in a cell range based on a single criterion?

• AVERAGEIF

• COUNTIF

• SUMIF

A conditional function that find the mean or average of all the values in a cell range based on a single criterion?

• AVERAGEIF

• COUNTIF

• SUMIF

A conditional function that counts the number of cells in a cell range based on a single criterion?

• AVERAGEIF

• COUNTIF

• SUMIF

A conditional function that adds all values in a cell range based on a multiple criteria?

• AVERAGEIFS

• COUNTIFS

• SUMIFS

A conditional function that counts the number of cells in a cell range based on a multiple criteria?

• AVERAGEIFS

• COUNTIFS

• SUMIFS

A conditional function that find the mean or average of all the values in a cell range based on a multiple criteria?

• AVERAGEIFS

• COUNTIFS

• SUMIFS

It tells what to do once the condition is met.

• EQUAL SIGN

• FUNCTION NAME

• ARGUMENT

It is a cell range where the criteria will be checked.

• CRITERIA

• RANGE

• SUM_RANGE

It is the set condition to know which cells or values will be computed?

• CRITERIA

• RANGE

• SUM_RANGE

It is the cell range where values will be summed up once the set condition is met.

• AVERAGE_RANGE

• CRITERIA_RANGE

• SUM_RANGE