Create the following excel sheetCreate an excel sheet named household.xlsxThese are your incomes for the monthJob-Income - $1000Parents contribution - $500 Total the incomes and display it on the screenThe following are your expenditures for the monthCar - $100Gas- $50Rent - $200Car Insurance-$100Food - $300Shopping - $100Misc - $100Travel - $100Total the expenditures and display it on the screenCalculate the difference between the income and expenditures and display it on the screen and name it Surplus/DeficitUsing the built-in functions in excel – calculate and display the maximum, minimum and average expenditureCreate a graph to display income and expenditures

GIVEN: Create the following excel sheet Create an excel sheet named household.xlsx Total the incomes…

Answered: Create the following excel sheet Create…

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

Related questions

Question

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
Create a graph to display income and expenditures