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
Q62: Unless you add a minus sign,the Pmt
Q69: The _ aggregate function returns the value
Q79: Match the following terms with their description:
I.
Q81: Match the following formatting options with their
Q82: Match the following terms with their description:
I.
Q83: Match the order of operation with its
Q84: Match the following terms with their examples:
I.
Q85: Match the following mathematical terms with how
Q87: Match the areas of the Expression Builder
Q100: A(n)_ function performs a calculation on an
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