Microsoft Excel 2003: Entering formulas in the Monthly Totals Column

Move to cell G6 under the title Monthly Totals. Choose one of the formulas you learned earlier to add each of the amounts in Parents for the four months. Use any of the four methods you desire. Your spreadsheet should look like the one to right, just before you copy the formulas.



After you have completed your formula copy it to cells G7 through G19. You will see some "stuff (zeroes)" in cells G10, 11, 12, and 18. This is because there was "nothing there" to add. So, go in and clean-up these cells by deleting the zeros in these cells.

Next, go to cells G9 and G17 and underline like you did before.