Monday, September 12, 2011

Adding Numbers

Next we want to learn how to add numbers.  There are several ways to do this.  Each method has its advantages and disadvantages.

Begin by moving your cursor to cell C9, and clicking-on cell C9.

Always move to the cell where you want the answer
to be located.


TYPE-IN METHOD

We want to add the three numbers in cells C6, C7 and C8.  To use this method  type-in (using the keys on the keyboard) the following formula in cell C9:

             = C6 + C7 + C8     

Your spreadsheet should look like the image to the right as you are typing in this equation.  Note:  you don’t have to use capital (upper case) letters – we only did this because they are easier to “see” in the tutorial.

Now – tap the Enter key.  Then, click on cell C9 again.  The total of these cells will now appear in C9. 




When you have completed typing your equation, you will see this formula in the area below the menu bar.



Change the number in cell C6 to 500 (and tap Enter).  See how the total AUTOMATICALLY recalculates!!!

No comments:

Post a Comment

This post confirms my ownership of the site and that this site adheres to Google AdSense program policies and Terms and Conditions.