Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create the following excel sheet Create an excel sheet named household.xlsx These are your incomes for the month Job-Income - $1000 Parents contribution - $500
- Create the following excel sheet
- Create an excel sheet named household.xlsx
- These are your incomes for the month
- Job-Income - $1000
- Parents contribution - $500
- Total the incomes and display it on the screen
- The following are your expenditures for the month
- Car - $100
- Gas- $50
- Rent - $200
- Car Insurance-$100
- Food - $300
- Shopping - $100
- Misc - $100
- Travel - $100
- Total the expenditures and display it on the screen
- Calculate the difference between the income and expenditures and display it on the screen and name it Surplus/Deficit
- Using the built-in functions in excel calculate and display the maximum, minimum and average expenditure
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started