Question: I need help please I really need help with this so please help me care files from the Internet can contain viruses. Unless you need

I need help please I really need help with this so please help me

I need help please I really need help with this so please

care files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X -SUM(B3:85) Budget Spreadsheet LU LE I Monthly Income Name: Estimated Actual Income from job 1,900.00 1,925.00 Other Income 1 Monthly Outcomes 250.00 Estimated Actual 220.00 Other Income 2 Total Monthly Income $ 2,150.00 Total Total Monthly Expenses 2,1.50.00 Difference of Income - Expenses Monthly Expenses Estimated Actual Rent/Mortgage 750.00 750.00 This assignment is to help you learn some of the basics of Excel. You may need to click on 'e 10 Heating editting' before you can start to make changes to this sheet. 80.00 90.00 11 Electric 75.00 75.00 1.) Click on cell B6 to see how the 'SUM' formula has been used to find the total estimated 12 Water/Utility 50.00 55.00 income. Put a similar formula in cells C6, B28 and C28 to find the totals for each budget are 13 Home Insurance 125.00 125.00 14 Credit Card 1 100.00 80.00 2.) Click on cell F4 to see how a reference was used to copy the total estimated income int 15 Credit Card 2 a similar formula to copy values into cells G4, F5 and G5. 16 Car Payment 200.00 200.00 3.) Enter formulas into cells F6 and G6 that find the difference of the income minus the ex Car insurance 50.00 50.00 each column. 18 Gasoline 200.00 175.00 19 Cable 75.00 75.00 4.) Did this person estimate to have a surplus or deficit at the end of the month? 20 Internet 50.00 50.00 21 Cell Phone 60.00 60.00 5.) Did this person actually have a surplus or deficit at the end of the month? 22 Food 200.00 210.00 6.) Change the value in cell C14 to 50. How does this affect the other values? 23 Clothing/Personal Care 20.00 30.00 24 Entertainment 80.00 75.00 7.) Put your name in cell G1. Childcare/Eldercare ac lotharne Sheet1 Type here to search O

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!