Purpose The purpose of this assignment is for students to demonstrate proficiency in Microsoft…

Microsoft Excel Project
Purpose The purpose of this assignment is for students to demonstrate proficiency in Microsoft Excel by creating a spreadsheet that will be used to manage their own personal budget. Please note that you do not have to include actual values for your income and expenses; you can make up values, but they should be realistic.
Before attempting to design the spreadsheet in Microsoft Excel, students should search the Web for sample personal budgets to learn how they might be organized in a spreadsheet. We will not provide samples of what the finished product will look like. A main objective of this assignment is to demonstrate how to properly organize data in an Excel spreadsheet. Microsoft Office Help, online resources, and your instructors can help to provide proper guidance.
Content Requirements The spreadsheet should contain, in a logical format, the following information.

  1. The first part of the spreadsheet should show your income each month, for a 12-month period, that comes from all income sources. An example is below:
    Income Jan. Feb. Mar. Apr. May June July Aug. Sep. Oct. Nov. Dec. Employer $440 $400 $500 $560 $440 $550 $250 $390 $500 $440 $550 $300 Interest $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 Parental Assistance $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
  2. In a new row at the bottom of your income information, include a row that will display the total income per month 3. In a new column on the right side of your income information, include a column that will display the total income per category 4. The second part of the spreadsheet should show your estimated mandatory expenses each month, for a 12-month period. There should be some varying values, so you do not end up with all of the same values for every month, in every category. Mandatory expenses might include rent or house payments, grocery bills, utilities, and car payments, but not necessarily anything related to entertainment. An example is below:
    Expenses Jan. Feb. Mar. Apr. May June July Aug. Sep. Oct. Nov. Dec. Rent $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 Car Pymt. $170 $170 $170 $170 $170 $170 $170 $170 $170 $170 $170 $170 Utilities $60 $60 $60 $60 $60 $90 $90 $90 $90 $60 $60 $60 Cell Phone $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 Groceries $50 $60 $45 $50 $65 $50 $45 $50 $50 $50 $80 $80
  3. In a new row at the bottom of your expense information, include a row that displays the total expenses per month. To receive credit for this step, you must use an Excel formula or function to calculate the total, which should automatically recalculate if the values in the cells are modified.
    Page 1 of 6

<div class="