Exam 77-420 Microsoft Excel 2013
4. Apply Formulas and Functions
4.2 Summarize Data with Functions: Demonstrate How To Apply the Average Function
graphic1

What is the Average?

To calculate the Average, you need some business math.


1. Try it: Calculate the Average

Select Cell D6.

Go to Formulas ->Function Library.

Go to AutoSum.

Click on Average.

 

graphic2

 

What Do You See? The equation in Cell D6 is =AVERAGE(D2:D5)...wait!

Formulas->Function Library->AutoSum ->Average
Another Memo: As you add a new function, add a Label in the cell to the left of it (in Column C) so you know which function you are using.

 
Memo to Self: Proof the formulas. The example on this page is wrong!