Functions are predefined formulas that perform calculations. Some of the most popular Excel calculations have converted into functions for easier use. The table below highlights the most commonly used functions in Excel:
| To calculate the... | Use this function in Excel | Example | What it does |
|---|---|---|---|
| Mean | AVERAGE | =AVERAGE (A1:A7) | Returns the average (or mean) value of the cells in the range A1 to A7 |
| Maximum | MAX | =MAX(A1:A7) | Returns the highest value of the cells in the range A1 to A7 |
| Minimum | MIN | =MIN(A1:A7) | Returns the lowest value of the cells in the range A1 to A7 |
| Standard Deviation | STDEV | =STDEV(A1:A7) | Returns an estimate of the standard deviation of a population, where the sample is all of the data to be summarized; in this example, the cells in the range A1 to A7 |
To use a function in your formula, use the 'Insert Function' option from the Insert Toolbar.
Many websites have examples of how to use Functions:
Using Excel Functions from Excel-2010.com