You have decided that it might be a good idea to create a personal household bud

Question

You have decided that it might be a good idea to create a personal household budget for yourself. You know you are able to pay all your bills, attend school, and even have money left for fun get a-ways. But you really want to be able to save money to purchase a house after you graduate with your degree. You decide to create a personal budget and decide to use MS Excel 2007 to help you with this. You begin to gather your pay stubs and all the bills you have to pay each month and sit down in front of your computer and open Excel 2007.

Project Details
Open Microsoft Excel 2007. You will begin with a new worksheet.
Step 1: Create and format a row to show the months for the year (Jan-Dec).
Step 2: Create and format a row, beneath the month row, to show yearly income for each month (Jan-Dec), and properly label the row and value.
Step 3: Add each expense in a separate row (as identified in step 4) and properly label each row and value.
Step 4: For the expenses and income, create a year's history by month. Use different values for each month. For example, for electric, you would pick a number between $125 and $142 for January, a different number between $125 and $142 for February, and so on. Feel free to make up the amounts you use for each expense.
Step 5: Select an appropriate style for your budget and apply it to your worksheet.

Explanation / Answer

months Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 Expenses Electrical bill 123 130 115 135 145 138 142 141 126 137 126 144 Petrol bill 25 26 20 30 29 35 40 26 24 28 32 36 Income after expenses $852 $844 $865 $835 $826 $827 $818 $833 $850 $835 $842 $820 Total income per year after expenses is $10,047

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.