Solved

Match the Following Terms with the Corresponding Description

Question 96

Matching

Match the following terms with the corresponding description.

Premises:

Responses:

DAVERAGE

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.

DSUM

Identifies the lowest value in a database column that matches conditions you specify

DMAX

Analyze data for selected records only in a database table

DMIN

Adds the values in a numeric database column based on conditions you specify in a criteria range

Database function

Determines the arithmetic mean,or average,of numeric entries in a database column that match conditions you specify

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:

Premises:

Responses:

DAVERAGE

DSUM

DMAX

DMIN

Database function