Matching
Identify the letter of the choice that best matches the phrase or definition.
Premises:
Calculates the average of values within a range of cells that meet multiple conditions
Responses:
SUMIF
DAVERAGE
COUNTIF
DSUM
AVERAGEIFS
AVERAGEIF
DCOUNT
DCOUNTA
SUMIFS
DSTDEV
COUNTIFS
DMIN
Correct Answer:
Premises:
Responses:
SUMIF
DAVERAGE
COUNTIF
DSUM
AVERAGEIFS
AVERAGEIF
DCOUNT
DCOUNTA
SUMIFS
DSTDEV
COUNTIFS
DMIN
Premises:
SUMIF
DAVERAGE
COUNTIF
DSUM
AVERAGEIFS
AVERAGEIF
DCOUNT
DCOUNTA
SUMIFS
DSTDEV
COUNTIFS
DMIN
Responses:
Related Questions
Q89: The _ function returns the number of
Q90: You can type a(n)_ to the left
Q91: A(n)_ specifies the type of condition the
Q92: The _ function calculates the difference between
Q93: If you edit a cell in a
Q95: In the Edit Formatting Rule dialog box
Q96: The _ function searches vertically down a
Q97: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TBX9149/.jpg" alt=" Given the flowchart
Q98: The _ qualifier references the header row
Q99: Identify the letter of the choice that