Matching
Identify the letter of the choice that best matches the phrase or definition.
Premises:
Counts the number of cells within a range that meet multiple criteria
Responses:
SUMIF
COUNTIF
AVERAGEIFS
DCOUNT
DSTDEV
DSUM
DAVERAGE
COUNTIFS
AVERAGEIF
SUMIFS
DMIN
DCOUNTA
Correct Answer:
Premises:
Responses:
SUMIF
COUNTIF
AVERAGEIFS
DCOUNT
DSTDEV
DSUM
DAVERAGE
COUNTIFS
AVERAGEIF
SUMIFS
DMIN
DCOUNTA
Premises:
SUMIF
COUNTIF
AVERAGEIFS
DCOUNT
DSTDEV
DSUM
DAVERAGE
COUNTIFS
AVERAGEIF
SUMIFS
DMIN
DCOUNTA
Responses:
Related Questions
Q77: The SUMIFS and AVERAGEIFS functions have identical
Q78: With the AVERAGEIFS function the associated criteria
Q79: A formula that includes a structured reference
Q80: The _ function returns the estimate of
Q81: The _ function is a logical function
Q83: Click the Home tab on the Ribbon
Q84: Identify the letter of the choice that
Q85: You can enter a column header in
Q86: The categories for a lookup table called
Q87: The COUNTIFS function counts the number of