Excel: A Question of Balance Page 1 2 3 4 5 6 7 8 9 10 11 12

What is the Average?

To calculate the Average, we need some business math. First, add the sum of the salaries. Then, divide the total by the number of employees.


Try it: Calculate the Average

Select Cell D5.

Click on Function.


Find AVERAGE in the list of functions and click it.

 

Excel will write the equation for you. Excel even outlines the data in Cell D2 through D4.

Home ->Edit ->Average