This appendix contains a complete listing of the Excel worksheet functions. The functions are arranged alphabetically 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 Function dialog box and click Help on This Function.
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.|
|CEILING||Rounds a number to the nearest integer or to the nearest multiple of significance.|
|CHIDIST||Returns the right-tailed probability of the chi-squared distribution.|
|CHIINV||Returns the inverse of the right-tailed probability of the chi-squared distribution.|
|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.|
|CRITBINOM||Returns the smallest value for which the cumulative binomial distribution is ...|