Purchase Solution

Create a sample spreadsheet that depicts a household budget

Not what you're looking for?

Ask Custom Question

You do not need to put in personal information or actual values if you do not wish, but you must include some data for each of the various categories and income and expense line items.

Content and Format Requirements
1. This spreadsheet should be divided into categories such as Income and Expenses. Within each of these categories there should be several line items. For example, under Expenses you might have items such as: Utilities, Auto, Rent/Mortgage, and so on.
2. For each line item, create a year's history by month. Identify each month by month and year such as "July 2005."
3. Create formulas or use the AutoSum function to calculate totals for line item categories and for each month.
4. Create Formulas or use the AutoSum function to have Excel compute the Total Annual Income and the Total Annual Expenses.
5. Name the worksheet tab "Budget Details."
6. On the second worksheet in the Excel workbook, include the Total Annual Expenses and Total Annual Income using cells from the Budget Details worksheet.
7. Create a formula to have Excel compute Annual Savings based on the values in those cells.
8. Include titles to identify all values.
9. Name the tab of the second worksheet "Annual Totals."
10. Save the worksheet.

Purchase this Solution

Solution Summary

The solution provides a detailed template for household budget in an Excel file.

Purchase this Solution


Free BrainMass Quizzes
Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.