Match the following aggregate functions with what they compute:
I. Avg
II. Sum
III. Count
IV. Min
V. Max
A. Counts the number of values in a column
B. Average of a column
C. Returns the lowest value
D. Returns the highest value
E. Totals the items in a column
Correct Answer:
Verified
Q25: Access will identify logical errors in calculated
Q48: You can add aggregate functions to calculated
Q49: If you want to see the results
Q53: You can enter an expression in the
Q60: If you are not using a totals
Q82: Match the order of operation with its
Q83: Match the following terms with their description:
I.
Q84: Match the following formulas with their resultant
Q85: Match the areas of the Expression Builder
Q86: Match the following formatting options with their
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