Before beginning this assignment you should thoroughly review Excel Worksheets Charts Formulas Functions and Tables from your course textbook Go! All in one: Computer concepts and applications. For this assignment you will use Microsoft Excel to develop a worksheet that details your personal expenses in at least four categories from the last three months. Some of these expense categories might include but are not limited to Mortgage Rent Utilities Phone Food Entertainment Tuition Childcare Clothing and Insurance.(These numbers may be fictitious.)
Part 1: The Spreadsheet
Please Note: While some calculations might be easy to do in your head or using a calculatormerely typing the answer into the appropriate cellthe point of this assignment is to get you accustomed to using formulas. In situations requiring frequently updated data or more complex calculations Excel is a very powerful tool if you know how to use it. Your grade is based on your demonstrated ability to use the required formulas.Part 2: The Chart
Below your table of monthly expenses you will create a chart using the numbers from your spreadsheet similar to the example below.
Save your file as LastnameFirstinitial_M3_A2.xls. Submit this document to the M3: Assignment 2 Dropbox by Tuesday January 31 2017.
Suggested challenge for intermediate users: Add a row or rows detailing your income and subtract the total expenditures from the total income.
Suggested challenge for advanced users: Use a formula function or combination of both to show your net gain or loss (income minus expenses summed over time) for the three-month period.