The following table looks into Excel 2016 functions that are especially useful or interesting. After you spend some time constructing formulas, you'll come up with your own list of useful or interesting functions.
Function | Returns |
---|---|
AVERAGE(number1,number2,…) | The average of the numbers in the cells listed in the arguments. |
COUNT(value1,value2,…) | The number of cells that contain the numbers listed in the arguments. |
MAX(number1,number2,…) | The largest value in the cells listed in the arguments. |
MIN(number1,number2,…) | The smallest value in the cells listed in the arguments. |
PRODUCT(number1,number2,…) | The product of multiplying the cells listed in the arguments. |
STDEV(number1,number2,…) | An estimate of standard deviation based on the sample cells listed in the argument. |
STDEVP(number1,number2,…) | An estimate of standard deviation based on the entire sample cells listed in the arguments. |
SUM(number1,number2,…) | The total of the numbers in the arguments. |
VAR(number1,number2,…) | An estimate of the variance based on the sample cells listed in the arguments. |
VARP(number1,number2,…) | A variance calculation based on all cells listed in the arguments. |