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:
Premises:
Responses:
COUNTIF
SUMIFS
AVERAGEIF
COUNTIFS
SUMIF
Premises:
COUNTIF
SUMIFS
AVERAGEIF
COUNTIFS
SUMIF
Responses:
Related Questions
Q85: Correlation is a tool included on the
Q91: Match each of the following concepts to
Q92: Match each of the following concepts to
Q93: Match each of the following concepts to
Q94: Match each of the following terms to
Q95: Match each of the following concepts to
Q96: Match each of the following concepts to
Q97: Match each of the following concepts to
Q98: Match each of the following concepts to
Q100: Match each of the following concepts to
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents