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:
Premises:
Responses:
Database function
DMIN
DMAX
DAVERAGE
DSUM
Premises:
Database function
DMIN
DMAX
DAVERAGE
DSUM
Responses:
Related Questions
Q40: Match the following terms with the corresponding
Q41: Match the following terms to their meanings:
Q42: When using a multiseries chart,a _ helps
Q43: Match the following terms with their descriptions:
Q44: Match the following features with the masters
Q46: Match the following terms with the corresponding
Q47: A column chart can be used to
Q48: When a table is embedded,any changes to
Q49: A poster is an example of a
Q50: Match the following Word options to the