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
Q59: You must have a query open in
Q60: The Calculated fields in Datasheet view can
Q61: The AVG function can only be used
Q62: The MAXIMUM aggregate function can work with
Q66: The SUM aggregate function can work with
Q67: A summary query is used to display
Q68: PEMDAS is a mnemonic device used to
Q69: Match each element of an expression with
Q73: Sum, Count, and Avg are all examples
Q74: ^ is the symbol for _.
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents