Matching
Match the following terms with the corresponding description.
Premises:
DSUM
DMIN
DAVERAGE
DMAX
DCOUNT
Responses:
Adds the values in a numeric database column based on conditions you specify in a criteria range
Identifies the lowest value in a database column that matches conditions you specify
Counts the cells that contain numbers in a database column that match conditions you specify
Determines the arithmetic mean,or average,of numeric entries in a database column that match conditions you specify
Identifies the highest value in a database column that matches conditions you specify
Correct Answer:
Premises:
Responses:
DSUM
DMIN
DAVERAGE
DMAX
DCOUNT
Premises:
DSUM
DMIN
DAVERAGE
DMAX
DCOUNT
Responses:
Related Questions
Q3: _ will return the interest paid for
Q27: Which of the following is the best
Q28: The _ function should be used to
Q32: The _ function returns a user defined
Q39: When the DAVERAGE function returns #DIV/0:<br>A)there are
Q42: Which database function will return the smallest
Q60: The _ function determines the arithmetic mean,or
Q92: The first argument of any database function
Q100: What is the second argument of the
Q103: Match the following terms with the corresponding