| 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 drag one more cell past the numbers you
want to as for the total area 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.
SUBTRACTION
In cell A19 type Net Income. Next, adjust the width of
column A.
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]
|
