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

Calculate the Balance Let's visualize how the equation works. In real words, the balance is whatever you had in the bank, minus any checks you wrote, plus any deposits. 4. Try This: Enter the Equation Select Cell F3 and type in =. The equals sign is on the top of the keyboard to the right of the row of numbers. All equations begin with “=.” Our calculation is =F2-D3+E3.   When you hit the Enter or Tab key on your keyboard, Excel will add it all up. Did you get $421.50?   Try it again on Cell F4. The equation would be: =F3-D4+E4. The answer should be $241.50. Select Cell F4. Copy and Paste the formula down to Row 10 What Did You See? Did you notice that the formula changed? Cell F5 now says =F4-D5+E5. This is an example of Relative references. Keep going...