Exam 77-882: Microsoft Excel 2010
Core
5. Applying Formulas and Functions
5.1. Create formulas: Revise Formulas The built in
functions in Microsoft Excel look for a range of cells. Sometimes, the
suggested range is NOT correct. In this
example, the equation added in the salaries, AND the SUM of the
salaries. This makes a Circular Reference, it adds itself again
and again and again. 2. Try it:
Select the Right Range Select Cell D6. Go to
Formulas->
Function Library. Go to AutoSum. Click on
Average. Use your
cursor to highlight (select) Cells D2:D4. 3. What Do You
See Now? The correct equation in Cell D6 is: =AVERAGE(D2:D4)
|
|
| |
