AutoSum Method

3   Method (Windows):  The last three methods work in all spreadsheets. Since we add numbers more than any other operation in spreadsheets, Excel spreadsheet has an additional feature - Auto Sum.  Move to cell C9 again and tap the delete key to erase your last formula.  Now look at the upper area of the screen, just below the menu bar, for a 3  (summation) symbol button.  Point to it and click with the left mouse button. WOW !!  Automatic addition!! Notice that the cells, you’d logically desire to add, have a marquee around them and that the SUM function is displayed in cell C9.  You’ll need to confirm that this is the correct formula.  So, tap the Enter key and the SUM function will now be set in cell C9.  Any time you want to add using this method just click-on the cell where you desire the total to be and click-on the  3  .

This would be a good time to save your work.

 PERIODICALLY SAVE AND REPLACE YOUR WORK IN CASE YOU LOOSE POWER TO YOUR COMPUTER

Now move to cell C17 and add the total Expenses in cells C13 to C16 - using each of the four methods.

While you are in cell C17, go ahead and place a line at the top of cell C17 using the format cells – border method that you learned on Page 5.

Subtraction

In cell A19 type-in Net Income.  Next, adjust the width of column A (Page 6).

In cell C19 we want to subtract the amount in for Expenses in cell C17 from the amount for Income in cell C9.  This can be accomplished by using either the Type-In Method or Point Method.  Go ahead and do this.  Don’t forget to tap the Enter key to confirm your formula.

                      [The formula should look like =C9‑C17]

More Cell Formatting

We want our numbers to look better.  To do this we'll include dollar signs and decimal points in our numbers. This is done by using the mouse.  Point to cell C6, hold down the left mouse button and drag down slowly to highlight cells C6 through C19.  Your screen should look like the one at the top of the next page.

Now point anywhere in the highlighted area and click the RIGHT mouse button. A pop-up menu will appear.  Click-on Format Cells (like you have done before).

Click-on the Number “Tab” at the top of the Format Cells menu screen.  Point to Currency and click-on Currency. 

Notice several things.  The right side shows the number of decimal places. The 2 is the default for cents.  We'll use 2.   Notice above the Decimal Places that there is a sample of what our number will look like.   At the lower right it shows how negative numbers can appear, depending on your choice.  When a negative number is calculated, it will appear with your

choice.  Now click-on OK.  All the numbers now have $.  If you have large numbers that are "too wide" for the current column width you will see some ######## in the cells where these numbers are located.  If this occurs in your spreadsheet, go ahead and widen the columns as you did previously (Page 6).

Your spreadsheet numbers should now look like the one on the left.

Division and Percent