When using a datasheet, explain what an aggregate function is and identify an aggregate function and explain what it does

What will be an ideal response?


An aggregate function performs calculations on an entire column of data returning a single value. The aggregate functions are:AVG -Calculates the average value for a column
COUNT - Counts the number of items in a column
MAXIMUM - Returns the item with the highest value
MINIMUM - Returns the item with the lowest value
SUM - Adds the items in a column

Computer Science & Information Technology

You might also like to view...

Workbooks that enable multiple users on a network to view and make changes to the workbook at the same time are called shared ________

A) workbooks B) worksheets C) views D) programs

Computer Science & Information Technology

It is always a good idea to record the FTP activity of the server into a(n) ____________________ file.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

Numeric data is any number that can be used in a mathematical calculation. _________________________  

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

A device-dependent program runs on computers provided by a variety of manufacturers.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology