Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

International Marketing And Export Management

Authors: Gerald Albaum , Alexander Josiassen , Edwin Duerr

8th Edition

1292016922, 978-1292016924

Students also viewed these Accounting questions