Microsoft Excel 2003: AutoSum METHOD - ∑

|


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 ∑ (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 ∑.

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

0 comments:

Post a Comment