Solved

Match the Following Terms with the Corresponding Description

Question 47

Matching

Match the following terms with the corresponding description.

Premises:

Responses:

Database function

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

DMIN

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.

DMAX

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

DAVERAGE

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

DSUM

Analyze data for selected records only in a database table

Premises:

Database function

DMIN

DMAX

DAVERAGE

DSUM

Responses:

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

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.

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

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

Analyze data for selected records only in a database table

Correct Answer:

Premises:

Responses:

Database function

DMIN

DMAX

DAVERAGE

DSUM

Related Questions