Solved

Match Each Aggregate Function with the Value It Returns

Question 26

Matching

Match each aggregate function with the value it returns:

Premises:
Avg
Count
Maximum
Minimum
Sum
Responses:
Returns the data item with the highest value
Returns the data item with the lowest value
Returns the mean value of a group of numbers
Returns the total value of a column of numbers
Returns the number of fields containing data

Correct Answer:

Avg
Count
Maximum
Minimum
Sum
Related Questions

Q5: _ is used to summarize data by

Q12: You can use Pmt to find the

Q28: Match the following terms to their meanings:

Q30: Match each aggregate function with the value

Q38: Function arguments are separated by _.

Q48: Calculated fields are created in the Datasheet

Q58: Expression Builder can be opened by clicking

Q59: Multiple arguments in a function are separated

Q61: Which of the following is the correct

Q79: Expression Builder inserts _ that tell you