Since, we add numbers more than any other operationin spreadsheets, Excel spreadsheet has an additional feature - Auto Sum. Move to cell C9 again and press 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. It is added automatically. Observe that thecells you would logically desire to add, have a marquee around them and that the SUM function is displayed in cell C9. You will need to confirm that this is the correct formula.
Press the Enter key and the SUM function will now be set in cell C9. 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, place a line at the top of this cell using the format cells – border method that you learned earlier.
SUBTRACTION
Type Net Income in cell A19.. Next, adjust the width of column A. From cell C19, we want to subtract the amount 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. Do not forget to press the Enter key to confirm your formula. [The formula should look like this =C9-C17]
No comments:
Post a Comment