Information Technology Center

Introduction To Microsoft Excel

Excel Lesson Four (Part I)

Every home has monthly expenses. These expenses can be recorded in an Excel worksheet.

Lesson Four - Home Expenses Worksheet

DESCRIPTION:

This lesson demonstrates how Excel can be used to manage personal finances in the home.

SPECIFIC OBJECTIVES:

At the end of the lesson students should be able to :

  • Create a list of home expenses
  • Correctly use the Sum Function
  • Format numeric data as currency
  • Edit the worksheet

Format for the SUM function

=SUM(first cell address : last cell address)

  1. The function starts with the equal sign =
  2. The word SUM follows the equal sign
  3. An open baracket ( is next followed by the first cell address
  4. A colon : comes next followed by the last cell address of the range
  5. End with a closing bracket )

Home Expenses Worksheet

Exercise 4.1

Start Excel if it is not already displayed on your desktop then click on a new worksheet tab.

Enter the data exactly as displayed below. The SUM function is used to add up all expenses for the month.

A B C D E
1 Home Expenses Month 1 Month 2 Month 3 Total
2 Bank Loan 350
3 Groceries 750
4 Rent 650
5 Electricty 150
6 Telephone 250
7 Transportation 450
8 Cable 210
9 Monthly Total =SUM(B2:B8)

Table 4A

The value 2810 will be displayed in cell B9 after you enter the SUM function and press the Enter Key.

If 2810 is not displayed after you press Enter then check your data and formula again.

Change Cell Format

You must be on the HOME tab for this exercise

  1. Click in cell B9
  2. Locate the Number Ribbon
  3. Click on the Dropdown List
  4. Choose Currency from the list

You can select another option from the list and observe how it affects the value displayed in cell B9. After you examine this feature choose the Currency option agian.

Exercise 4.2

Expenses for Month 1 are the same for Month 2 and Month 3, except for the changes listed below. Compelete the worksheet - Table 4A, before attempting this exercise.

  1. Use the sum function only in column E
  2. If the Loan was repaid in Month 2 what value should there be in Cell E2?
  3. How much was spent for Month 3 if the telephone bill was $50 less than Month 1
  4. Change MONTH 1 to the current month, change MONTH 2 to next month and Month 3 to the month after next month
  5. Change the Sheet name to HOME
  6. Save the file on your flash drive

Test Yourself

Choose the correct answer
Questions Options Verify
 1)  Table 4A has nine rows and five columns True False
 2)  The value 750 is located in cell C3 True False
 3)  The value 210 is located in cell B8 True False
 4)  Range A1 : E1 contains labels. True False
 5)  250 was spent on Transportation. True False

Activity 4

Excel Lesson Four - Sales Report

...........

End of Lesson Four - A Home Expenses Worksheet

The Tutor
Do you have a question or a comment?
tutordam@yahoo.com

Site Comments to: Webmaster