Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I really need help please help me X -SUM(B3:B5) U I Budget Spreadsheet Name: Monthly Income Estimated Actual Income from job 1,900.00 1,925.00 Monthly Outcomes

I really need help please help me

image text in transcribed
X -SUM(B3:B5) U I Budget Spreadsheet Name: Monthly Income Estimated Actual Income from job 1,900.00 1,925.00 Monthly Outcomes Estimated Actual Other Income 1 250.00 220.00 Total Monthly Income $ 2,150.00 Other Income 2 Total Monthly Expenses Total 2,150.00 Difference of Income - Expenses Monthly Expenses Estimated Actual Rent/Mortgage 750.00 This assignment is to help you learn some of the basics of Excel. You may need to click on 'end 750.00 editting' before you can start to make changes to this sheet. 10 Heating 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 m 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 area. 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 into ce 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 expens 17 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 23 Clothing/Personal Care 20.00 30.00 6.] Change the value in cell C14 to 50. How does this affect the other values? 24 Entertainment 80.00 75.00 7.) Put your name in cell G1 25 Childcare/Eldercare Sheet1 Type here to search Z

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cost Management

Authors: Don R Hansen, Maryanne M Mowen, Dan L Heitger

5th Edition

357141091, 978-0357141090

More Books

Students also viewed these Accounting questions

Question

Peoples understanding of what is being said

Answered: 1 week ago

Question

The quality of the proposed ideas

Answered: 1 week ago