Solved

Match the Following Terms with the Corresponding Description

Question 45

Matching

Match the following terms with the corresponding description.

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:

Database function
DMIN
DMAX
DAVERAGE
DSUM
Related Questions