I am needing assistance on this assignment. I have started it but I am stuck at the total page (the fourth sheet under the bullet #1). I know I am probably making this way harder than it needs to be and need clarification to this. I will attach the homework assignment and what I have done so far. I would like to work with someone in completing this assignment. I will need to know how to perform these actions and the steps to take to continue in my course. The first attachment is the assignment instruction, etc and the second is what I have done thus far.

MIS 3310 - Excel Project PROJECT PARAMETERS: This project is very open ended to give you a chance to be creative and figure some things out for yourself. Open-ended projects also eliminate the temptation to cheat - your spreadsheets will not look anything like the other students' files. I've listed requirements and suggestions, but it is up to you to make your file attractive, easy-to-read, and mathematically correct. Please try to figure things out by yourself, but if you need help, try google, myitlab (if you still have access), youtube, Microsoft online tutorials, etc. OUTPUT: You will submit one Excel file with at least 8 sheets. All of the information will be made up, just try to make it a little realistic. You can look online for examples. Complete ALL of the following: 1. Budget for an individual or a company: a sheet for January - April, a sheet for May - August, a sheet for September - December, and a total sheet which pulls numbers from the first 3 sheets. 2. A GPA spreadsheet: list courses for two semesters (15 hours per semester), grades, etc. and a formula to determine GPA. This doesn't have to be real information. Use a 4.0 scale for the GPA. 3. Payroll sheet: Include at least 10 employees, you can determine what data will be needed, but make sure you include gross pay, taxes, health insurance, and net pay. 4. General Spreadsheet: This sheet can be anything you like - inventory list, contact list, etc. You might want to use it to include formulas and features that don't make sense in the other spreadsheets. 5. Create some data that you can use for a Pivot Table. Then create a pivot table and list 4 or 5 questions (and their answers) that your pivot table will answer. Here is a helpful site for pivot tables: https://www.gcflearnfree.org/excel2016/intro-to-pivottables/1/ REQUIRED: You must use the following at least once: Addition, subtraction, multiplication, division Lookup formula Image (insert a pic) Cell references (to pull a number from one sheet into another sheet) PMT formula IF formula List of features/formulas used (so that I don't miss something) Graph Absolute reference GRADING : Use of required features - 60% Formatting (are things easy to read, is the graph formatted correctly, etc.) - 20% Inclusion of additional features/formulas (suggestions - lookup formula, borders, etc.) - 20% BUDGET SHEET JANUARY TO APRIL January February March Income Salary 1 Salary 2 Total $4,000.00 $4,000.00 $4,000.00 $4,000.00 $1,100.00 $1,100.00 $1,100.00 $1,100.00 $5,100.00 $5,100.00 $5,100.00 $5,100.00 $250.00 $250.00 $250.00 $120.00 $120.00 $120.00 $690.00 $690.00 $690.00 $605.00 $605.00 $605.00 $250.00 $250.00 $250.00 $185.00 $185.00 $185.00 $225.00 $225.00 $225.00 $65.00 $65.00 $65.00 $715.00 $715.00 $715.00 $14.00 $14.00 $14.00 $3,119.00 $3,119.00 $3,119.00 $340.00 $290.00 $310.00 $280.00 $290.00 $315.00 $425.00 $375.00 $415.00 $1,045.00 $955.00 $1,040.00 $936.00 $1,026.00 $941.00 Fixed Expenses Auto Ins. $250.00 Baseball $120.00 Car note 1 $690.00 Car note 2 $605.00 Cell Phone $250.00 Cheer $185.00 Credit cards $225.00 Internet $65.00 Mortgage $715.00 Netflix $14.00 Total $3,119.00 Variable Expenses Electric $305.00 Fuel $300.00 Groceries $400.00 Total $1,005.00 Difference April $976.00 BUDGET SHEET MAY TO AUGUST Income Salary 1 Salary 2 Total May June $4,000.00 $4,000.00 $4,000.00 $4,000.00 $1,100.00 $1,100.00 $1,100.00 $1,100.00 $5,100.00 $5,100.00 $5,100.00 $5,100.00 $250.00 $250.00 $250.00 $120.00 $120.00 $120.00 $690.00 $690.00 $690.00 $605.00 $605.00 $605.00 $250.00 $250.00 $250.00 $185.00 $185.00 $185.00 $225.00 $225.00 $225.00 $65.00 $65.00 $65.00 $715.00 $715.00 $715.00 $14.00 $14.00 $14.00 $3,119.00 $3,119.00 $3,119.00 $320.00 $400.00 $300.00 $275.00 $315.00 $305.00 $390.00 $405.00 $375.00 $985.00 $1,120.00 $980.00 $996.00 $861.00 $1,001.00 Fixed Expenses Auto Ins. $250.00 Baseball $120.00 Car note 1 $690.00 Car note 2 $605.00 Cell Phone $250.00 Cheer $185.00 Credit cards $225.00 Internet $65.00 Mortgage $715.00 Netflix $14.00 Total $3,119.00 Variable Expenses Electric $285.00 Fuel $295.00 Groceries $380.00 Total $960.00 Difference $1,021.00 July August BUDGET SHEET SEPTEMBER TO DECEMBER September October NovemberDecember Income Salary 1 Salary 2 Total $4,000.00 $4,000.00 $4,000.00 $4,000.00 $1,100.00 $1,100.00 $1,100.00 $1,100.00 $5,100.00 $5,100.00 $5,100.00 $5,100.00 $250.00 $250.00 $250.00 $120.00 $120.00 $120.00 $690.00 $690.00 $690.00 $605.00 $605.00 $605.00 $250.00 $250.00 $250.00 $185.00 $185.00 $185.00 $225.00 $225.00 $225.00 $65.00 $65.00 $65.00 $715.00 $715.00 $715.00 $14.00 $14.00 $14.00 $3,119.00 $3,119.00 $3,119.00 $305.00 $285.00 $270.00 $280.00 $290.00 $315.00 $425.00 $375.00 $415.00 $1,045.00 $955.00 $1,040.00 $936.00 $1,026.00 $941.00 Fixed Expenses Auto Ins. $250.00 Baseball $120.00 Car note 1 $690.00 Car note 2 $605.00 Cell Phone $250.00 Cheer $185.00 Credit cards $225.00 Internet $65.00 Mortgage $715.00 Netflix $14.00 Total $3,119.00 Variable Expenses Electric $310.00 Fuel $300.00 Groceries $400.00 Total $1,005.00 Difference $976.00 Hello. Please email me at gnichols@gt.rr.com so we can conclude the information I will need to know for this class and assignment. I will rate my answer once I hear from you. Thank you. Hello. Please email me at gnichols@gt.rr.com so we can conclude the information I will need to know for this class and assignment. I will rate my answer once I hear from you. Thank you