Solved

Match the Following Terms with the Corresponding Description

Question 20

Matching

Match the following terms with the corresponding description:

Premises:
SUMIF
AVERAGEIF
COUNTIF
SUMIFS
AVERAGEIFS
Responses:
Counts the number of cells within a range that meet the given condition.
Adds the cells specified by a given set of conditions or criteria
Finds the mean for the cells specified by a given set of conditions or criteria.
Adds the cells specified by on a given condition or criteria
Finds the mean for the cells specified by a given condition or criteria

Correct Answer:

SUMIF
AVERAGEIF
COUNTIF
SUMIFS
AVERAGEIFS
Related Questions

Q15: Match the following actions to their corresponding

Q16: Match the following terms with the corresponding

Q17: Match the following terms with the corresponding

Q18: Match the following clues with each correct

Q19: When data is entered,a(n)_ is used to

Q21: A(n)_ allows the user to select a

Q22: Match the following terms with the corresponding

Q23: The IIf function requires _ parameters.<br>A)0<br>B)1<br>C)2<br>D)3

Q24: Match the following descriptions, sections, and categories

Q25: Match the following terms with the corresponding