Matching
Match the following terms with the corresponding description.
Premises:
DCOUNT
DMAX
DSUM
DAVERAGE
DMIN
Responses:
Adds the values in a numeric database column based on conditions you specify in a criteria range
Counts the cells that contain numbers in a database column that match conditions you specify
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
Determines the arithmetic mean,or average,of numeric entries in a database column that match conditions you specify
Correct Answer:
Premises:
Responses:
DCOUNT
DMAX
DSUM
DAVERAGE
DMIN
Premises:
DCOUNT
DMAX
DSUM
DAVERAGE
DMIN
Responses:
Related Questions
Q43: Which database function should be used to
Q44: =INDEX(A2:<br>B5,MATCH(MAX(B2:<br>B5),B2:<br>B5,0),1)is an example of a nested function.
Q45: The MATCH function match_type must be set
Q46: In the function =IF(E5<J7,F5*K7,IF(E5<=J8,F5*K8,F5*K9)),F5*K7 is the:<br>A)Value_if_true.<br>B)Value_if_false.<br>C)Logical_test.<br>D)Modifier.
Q47: When using Advanced Filtering,the criteria range must
Q49: Match the following terms with the corresponding
Q50: If payments are made at the beginning
Q51: Excel permits _ IF statements in one
Q52: The _ function should be used to
Q92: The first argument of any database function