Matching
Identify the letter of the choice that best matches the phrase or definition.
Premises:
Database function that returns the minimum value in search column that meets specified criteria
Responses:
AVERAGEIF
COUNTIFS
DAVERAGE
DSUM
DSTDEV
DMIN
DCOUNT
SUMIFS
SUMIF
AVERAGEIFS
DCOUNTA
COUNTIF
Correct Answer:
Premises:
Responses:
AVERAGEIF
COUNTIFS
DAVERAGE
DSUM
DSTDEV
DMIN
DCOUNT
SUMIFS
SUMIF
AVERAGEIFS
DCOUNTA
COUNTIF
Premises:
AVERAGEIF
COUNTIFS
DAVERAGE
DSUM
DSTDEV
DMIN
DCOUNT
SUMIFS
SUMIF
AVERAGEIFS
DCOUNTA
COUNTIF
Responses:
Related Questions
Q67: When you create a formula that references
Q68: With the DATEIF function the _ interval
Q69: The _ function is a logical function
Q70: The COUNTIF function is sometimes referred to
Q71: If you are creating a calculated column
Q73: An alternative to using several nested IF
Q74: If you are not sure of a
Q75: The _ range is an area in
Q76: _ the top portion of a column
Q77: The SUMIFS and AVERAGEIFS functions have identical