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

What is the Average?

To calculate the Average, you need some business math.


Try it: Calculate the Average

Select Cell D6.

Go to Formulas -> AutoSum.

Click on Average.

 

 

What Do You See? Microsoft Excel created an equation in Cell D6: =SUM(D2:D5)...wait!

Formulas->AutoSum ->Average

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

 

  Microsoft Excel 2007 Exam 77-602 Topic: 3. Creating and Modifying Formulas

  3.3. Summarize data using subtotals       

  3.3.1.   Create and modify list ranges: Create a formula that finds the average of displayed values in a filtered list