Matching
Match each aggregate function with the value it returns:
Premises:
Sum
Count
Avg
Maximum
Minimum
Responses:
Returns the number of fields containing data
Returns the mean value of a group of numbers
Returns the total value of a column of numbers
Returns the data item with the lowest value
Returns the data item with the highest value
Correct Answer:
Premises:
Responses:
Sum
Count
Avg
Maximum
Minimum
Premises:
Sum
Count
Avg
Maximum
Minimum
Responses:
Related Questions
Q5: _ is used to summarize data by
Q6: A summary query is used to display
Q7: The Pmt function returns the monthly payment
Q8: A(n)_ displays the results of the aggregate
Q11: Following the rules for the order of
Q12: It is a good habit to use
Q13: Which of the following is NOT a
Q14: When using Design view,you click Totals in
Q64: Following the order of operations, 3+2*6 evaluates
Q70: Consider the following equation: 3 * (6