Matching
Match each of the following functions to its best description of its purpose:
Premises:
COUNTIFS
AVERAGEIF
SUMIF
SUMIFS
COUNTIF
Responses:
Calculates the total of a range of values when a specified condition is met
Calculates the total value of cells in a range that meet multiple criteria
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 number of cells in a range when a specified condition is met
Correct Answer:
Premises:
Responses:
COUNTIFS
AVERAGEIF
SUMIF
SUMIFS
COUNTIF
Premises:
COUNTIFS
AVERAGEIF
SUMIF
SUMIFS
COUNTIF
Responses:
Related Questions
Q90: A histogram is a pie chart created
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