Solved

Match the Following Aggregate Functions with What They Compute

Question 59

Multiple Choice

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:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q9: What are predefined computations that perform complex

Q11: What best describes the concept of syntax?<br>A)Predefined

Q24: Access will identify logical errors in calculated

Q26: When you add _ to a query

Q33: Calculating values will help to avoid inconsistencies.

Q44: If you type the name of a

Q49: When creating a calculated field a(n)_ is

Q50: In the formula,3*[BaseSalary],the 3 is considered a(n)_.<br>A)variable<br>B)field<br>C)argument<br>D)constant

Q69: The _ aggregate function totals the items

Q79: If you want to see the results