| DATE
= Returns the serial number of a
particular date |
| DATEVALUE = Converts a date in the form of text to a
serial number |
| DAY = Converts a serial number to a day of the
month |
| DAYS360 = Calculates the number of days between
two dates based on a 360-day year |
| EDATE = Returns the serial number of the date
that is the indicated number |
| of months before or after the
start date |
| EOMONTH = Returns the serial number of the last
day of the month before or after |
| a specified number of months |
| HOUR = Converts a serial number to an hour |
| MINUTE = Converts a serial number to a minute |
| MONTH = Converts a serial number to a month |
| NETWORKDAYS = Returns the number of whole workdays
between two dates |
| NOW = Returns the serial number of the current
date and time |
| SECOND = Converts a serial number to a second |
| TIME = Returns the serial number of a
particular time |
| TIMEVALUE = Converts a time in the form of text to a
serial number |
| TODAY = Returns the serial number of today's
date |
| WEEKDAY = Converts a serial number to a day of the
week |
| WEEKNUM = Converts a serial number to a number
representing where the week |
| falls numerically with a year |
| WORKDAY = Returns the serial number of the date
before or after a |
| specified number of workdays |
| YEAR = Converts a serial number to a year |
| YEARFRAC = Returns the year fraction representing
the number of whole days |
| between start_date and
end_date |
| AVEDEV = Returns the average of the absolute
deviations of data points from their mean |
| AVERAGE = Returns the average of its arguments |
| AVERAGEA = Returns the average of its arguments,
including numbers, text |
| and logical values |
| BETADIST = Returns the beta cumulative distribution
function |
| BETAINV = Returns the inverse of the cumulative
distribution function for |
| a specified beta distribution |
| BINOMDIST = Returns the individual term binomial
distribution probability |
| CHIDIST = Returns the one-tailed probability of
the chi-squared distribution |
| CHIINV = Returns the inverse of the one-tailed
probability of the chi-squared distribution |
| CHITEST = Returns the test for independence |
| CONFIDENCE = Returns the confidence interval for a
population mean |
| CORREL = Returns the correlation coefficient
between two data sets |
| COUNT = Counts how many numbers are in the list
of arguments |
| COUNTA = Counts how many values are in the list
of arguments |
| COUNTBLANK = Counts the number of blank cells within
a range |
| COUNTIF = Counts the number of nonblank cells
within a range that meet the given criteria |
| COVAR = Returns covariance, the average of the
products of paired deviations |
| CRITBINOM = Returns the smallest value for which the
cumulative binomial |
| distribution is less than or
equal to a criterion value |
| DEVSQ = Returns the sum of squares of deviations |
| EXPONDIST = Returns the exponential distribution |
| FDIST = Returns the F probability distribution |
| FINV = Returns the inverse of the F probability
distribution |
| FISHER = Returns the Fisher transformation |
| FISHERINV = Returns the inverse of the Fisher
transformation |
| FORECAST = Returns a value along a linear trend |
| FREQUENCY = Returns a frequency distribution as a
vertical array |
| FTEST = Returns the result of an F-test |
| GAMMADIST = Returns the gamma distribution |
| GAMMAINV = Returns the inverse of the gamma
cumulative distribution |
| GAMMALN = Returns the natural logarithm of the
gamma function, Γ(x) |
| GEOMEAN = Returns the geometric mean |
| GROWTH = Returns values along an exponential
trend |
| HARMEAN = Returns the harmonic mean |
| HYPGEOMDIST = Returns the hypergeometric distribution |
| INTERCEPT = Returns the intercept of the linear
regression line |
| KURT = Returns the kurtosis of a data set |
| LARGE = Returns the k-th largest value in a data
set |
| LINEST = Returns the parameters of a linear trend |
| LOGEST = Returns the parameters of an exponential
trend |
| LOGINV = Returns the inverse of the lognormal
distribution |
| LOGNORMDIST = Returns the cumulative lognormal
distribution |
| MAX = Returns the maximum value in a list of
arguments |
| MAXA = Returns the maximum value in a list of
arguments, including numbers, |
| text, and logical values |
| MEDIAN = Returns the median of the given numbers |
| MIN = Returns the minimum value in a list of
arguments |
| MINA = Returns the smallest value in a list of
arguments, including numbers, |
| text, and logical values |
| MODE = Returns the most common value in a data
set |
| NEGBINOMDIST = Returns the negative binomial
distribution |
| NORMDIST = Returns the normal cumulative
distribution |
| NORMINV = Returns the inverse of the normal
cumulative distribution |
| NORMSDIST = Returns the standard normal cumulative
distribution |
| NORMSINV = Returns the inverse of the standard
normal cumulative distribution |
| PEARSON = Returns the Pearson product moment
correlation coefficient |
| PERCENTILE = Returns the k-th percentile of values in
a range |
| PERCENTRANK = Returns the percentage rank of a value
in a data set |
| PERMUT = Returns the number of permutations for a
given number of objects |
| POISSON = Returns the Poisson distribution |
| PROB = Returns the probability that values in a
range are between two limits |
| QUARTILE = Returns the quartile of a data set |
| RANK = Returns the rank of a number in a list
of numbers |
| RSQ = Returns the square of the Pearson
product moment correlation coefficient |
| SKEW = Returns the skewness of a distribution |
| SLOPE = Returns the slope of the linear
regression line |
| SMALL = Returns the k-th smallest value in a
data set |
| STANDARDIZE = Returns a normalized value |
| STDEV = Estimates standard deviation based on a
sample |
| STDEVA = Estimates standard deviation based on a
sample, including numbers, |
| text, and logical values |
| STDEVP = Calculates standard deviation based on
the entire population |
| STDEVPA = Calculates standard deviation based on
the entire population, |
| including numbers, text, and
logical values |
| STEYX = Returns the standard error of the
predicted y-value for each x in the regression |
| TDIST = Returns the Student's t-distribution |
| TINV = Returns the inverse of the Student's
t-distribution |
| TREND = Returns values along a linear trend |
| TRIMMEAN = Returns the mean of the interior of a
data set |
| TTEST = Returns the probability associated with
a Student's t-test |
| VAR = Estimates variance based on a sample |
| VARA = Estimates variance based on a sample,
including numbers, text, and logical values |
| VARP = Calculates variance based on the entire
population |
| VARPA = Calculates variance based on the entire
population, including numbers, |
| text, and logical values |
| WEIBULL = Returns the Weibull distribution |
| ZTEST = Returns the one-tailed probability-value
of a z-test |
.JPG)
.JPG)