Matching
Match the following terms with the corresponding description.
Premises:
Database function
DMAX
DAVERAGE
DSUM
DMIN
Responses:
Identifies the lowest value in a database column that matches conditions you specify
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
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.
Correct Answer:
Premises:
Responses:
Database function
DMAX
DAVERAGE
DSUM
DMIN
Premises:
Database function
DMAX
DAVERAGE
DSUM
DMIN
Responses:
Related Questions
Q88: When using Advanced Filtering empty cells in
Q89: Which of the following has the ability
Q90: Match the following functions with the corresponding
Q91: The end_period argument should have the value
Q92: Which of the following database functions is
Q94: The criteria range of a database function
Q95: Which function will return the total number
Q96: Which of the following functions has the
Q97: _ will return the principal paid on
Q98: Which of the following functions returns the