Extracts from a database a single record that matches the specified criteria
GETDATA
GETDB
DGET
None of the Above
Returns the maximum value from selected database entries
DMAX
DBMAX
MAXDATA
Multiplies the values in a particular field of records that match the criteria in a database
DPRODUCT
DMIN
Returns data stored in a PivotTable
PIVOTTABLE
PIVOTDATA
GETPIVOTDATA
Converts a serial number to an hour
GETHOUR
HOUR
EHOUR
Returns the number of whole workdays between two dates
WORKDAY
NETWORKDAY
NETWORKDAYS
WORKDAYS
Returns the serial number of the current date and time
NOW
TIME
SYSDATE
SYSTIME
Estimates the standard deviation based on a sample of selected database entries
DAVERAGE
DSTDEV
DSTDEVP
Calculates the standard deviation based on the entire population of selected database entries
DVAR
Adds the numbers in the field column of records in the database that match the criteria
DSUM
DSTSUM
SUMDATA
ADD_DATA