Phase 2 Individual Project
mskoneStudents are always challenged with managing their budget. In addition to normal household expenses, they have college expenses to consider. You have decided to keep track of all of your expenses using an Excel spreadsheet application to help with financial responsibilities. You will use Excel to estimate your monthly college expenses for the school year.
In your worksheet, include the following information about your budget:
- Decide on your additionalexpense categories such as housing, food, electricity, transportation, water, etc. Add categories as needed.
- Determine your list of college expenses such as books, supplies, computer hardware and software. Add categories as needed.
- Identify all sources of monthly income and organize this in your spreadsheet. After you have entered this data into your spreadsheet, you will want to analyze this data. (Use comment feature)
- Include totals of expenses projected for each month. (SUM)
- Calculate the projected savings left over each month after the expenses have been paid. (Income subtract expenses)
- Highlight any months where there may be a challenge by a deficit in income.
- Determine the maximum and minimum expenses and highlight each a different color. (MAX, MIN)
In your Excel worksheet, remember to use the following key worksheet elements:
- Columns, rows, and cells
- Cell formatting
- Formulas to produce your calculations
- Use the comments feature to bring attention to 1 or 2 cells that contain values important to the analysis of the budget.
Please submit your assignment.
- 10 years ago
- 5
Answer(0)
Bids(0)
other Questions(10)
- HTT200 W9 Final
- Social science
- As an extension, use the semicircular tray half filled with water. Use the ray box to determine the crucial angle...
- 3060 - 627
- help
- how meany country are in the british empire
- m2a2
- my cat sleeps on the radiator what is the subject and verb in this sentence
- Why is it important to ensure that a population sample is unbiased? In your own words, give an example in...
- Jonathon has taken the GRE three times. Every time he takes it he gets a 500 on the math section....