Microsoft Office Tutorials and References
In Depth Information
Appendix 1: Excel Function
Reference
This appendix contains a complete listing of the Excel worksheet functions. The functions are arranged alphabet-
ically in tables by categories used by the Insert Function dialog box.
For more information about a particular function, including its arguments, select the function in the Insert Func-
tion dialog box and click Help on This Function.
An interactive workbook that contains this information is available at this topic's web-
site. The filename is worksheet functions.xlsx.
Table A-1: Compatibility Category Functions
Function
What It Does
BETADIST
Returns the cumulative beta probability density function.
BETAINV
Returns the inverse of the cumulative beta probability density function.
BINOMDIST
Returns the individual term binomial distribution probability.
Rounds a number to the nearest integer or to the nearest multiple of signi-
ficance.
CEILING
CHIDIST
Returns the one-tailed probability of the chi-squared distribution.
Returns the inverse of the one-tailed probability of the chi-squared distribu-
tion.
CHIINV
CHITEST
Returns the test for independence.
CONFIDENCE
Returns the confidence interval for a population mean.
COVAR
Returns covariance, the average of the products of paired deviations.             Search JabSto ::

Custom Search