Match the following functions with their descriptions:

I. Sum
II. Average
III. Maximum
IV. Count
V. Minimum

A. Displays the item with the lowest value.
B. Can only be used with Currency, Date/Time, Decimal and Number data types.
C. Can only be used with Currency, Decimal and Number data types.
D. Displays the item with the highest value.
E. Can be used with all data types, except complex repeating scalar data.

C, B, D, E, A

Computer Science & Information Technology

You might also like to view...

Match the following terms to their meanings:

I. Delimited A. Data format where every field has the same number of II. Transpose possible characters III. CSV B. Data format where each field is separated by a character such IV. Access as a tab V. Fixed field width C. Data format that uses commas to separate values in a record D. The Microsoft Office database program E. A command that allows you to switch data between columns and rows

Computer Science & Information Technology

Any organization within the government can be held responsible if information they store about an individual is found to be incorrect

a. True b. False

Computer Science & Information Technology