Matching
Match each aggregate function with the value it returns:
Premises:
Minimum
Sum
Count
Maximum
Avg
Responses:
Returns the total value of a column of numbers
Returns the number of fields containing data
Returns the mean value of a group of numbers
Returns the data item with the lowest value
Returns the data item with the highest value
Correct Answer:
Premises:
Responses:
Minimum
Sum
Count
Maximum
Avg
Premises:
Minimum
Sum
Count
Maximum
Avg
Responses:
Related Questions
Q7: The Pmt function returns the monthly payment
Q22: It is NOT possible to add a
Q23: A constant is a value that remains
Q24: A _ query has an additional row
Q32: A query with a Total row is
Q38: Function arguments are separated by _.
Q45: To display the total row,you click Totals
Q69: A(n)_ contains an additional row in the
Q81: When designing an expression for a calculated
Q88: ^ is the symbol for _.