How to Use Common Functions in Excel 2016

By Peter Weverka

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.

Common Functions and Their Use
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.