Solved

Identify the Letter of the Choice That Best Matches the Phrase

Question 100

Matching

Identify the letter of the choice that best matches the phrase or definition.

Premises:
Used to calculate the average of values in a range that meet criteria you specify
Responses:
SUMIFS
DSTDEV
COUNTIFS
SUMIF
DSUM
COUNTIF
DCOUNT
AVERAGEIF
AVERAGEIFS
DCOUNTA
DMIN
DAVERAGE

Correct Answer:

SUMIFS
DSTDEV
COUNTIFS
SUMIF
DSUM
COUNTIF
DCOUNT
AVERAGEIF
AVERAGEIFS
DCOUNTA
DMIN
DAVERAGE
Related Questions

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

Q101: Functions that perform summary data analysis on

Q102: The IF function results in two values

Q103: In many situations the value you store

Q104: A formula must start with a(n)_.<br>A)plus sign<br>B)minus

Q105: The _ function calculates the difference between