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
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
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).
Numeric data is any number that can be used in a mathematical calculation. _________________________
Answer the following statement true (T) or false (F)
A device-dependent program runs on computers provided by a variety of manufacturers.
Answer the following statement true (T) or false (F)