Matching
Identify the letter of the choice that best matches the phrase or definition.
Premises:
Database function that returns the average of the values that meet specified criteria
Responses:
AVERAGEIF
COUNTIFS
DAVERAGE
DSTDEV
AVERAGEIFS
SUMIF
DSUM
SUMIFS
COUNTIF
DCOUNTA
DMIN
DCOUNT
Correct Answer:
Premises:
Responses:
AVERAGEIF
COUNTIFS
DAVERAGE
DSTDEV
AVERAGEIFS
SUMIF
DSUM
SUMIFS
COUNTIF
DCOUNTA
DMIN
DCOUNT
Premises:
AVERAGEIF
COUNTIFS
DAVERAGE
DSTDEV
AVERAGEIFS
SUMIF
DSUM
SUMIFS
COUNTIF
DCOUNTA
DMIN
DCOUNT
Responses:
Related Questions
Q111: _ references make it easier to create
Q112: If a formula is in a calculated
Q113: All the logical conditions listed in an
Q114: The _ error value means that the
Q115: In most cases a formula should use
Q117: Nesting IF functions will allow for three
Q118: Whenever you enter a formula into an
Q119: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TBX9149/.jpg" alt=" According to the
Q120: Although a criteria range often includes all
Q121: To retrieve a particular value from a