Solved

Match the Following Terms with the Corresponding Description

Question 103

Matching

Match the following terms with the corresponding description.

Premises:
DAVERAGE
DSUM
DMAX
DMIN
Database function
Responses:
Identifies the highest value in a database column that matches conditions you specify.For example,you can use the DMAX function to determine the highest salary of account reps in Boston.
Identifies the lowest value in a database column that matches conditions you specify
Analyze data for selected records only in a database table
Adds the values in a numeric database column based on conditions you specify in a criteria range
Determines the arithmetic mean,or average,of numeric entries in a database column that match conditions you specify

Correct Answer:

DAVERAGE
DSUM
DMAX
DMIN
Database function
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

Q102: Match the following terms with the corresponding