Answered step by step
Verified Expert Solution
Link Copied!

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

  1. Create the following excel sheet
  1. Create an excel sheet named household.xlsx
  2. These are your incomes for the month
  1. Job-Income - $1000
  2. Parents contribution - $500

  1. Total the incomes and display it on the screen
  2. The following are your expenditures for the month
  1. Car - $100
  2. Gas- $50
  3. Rent - $200
  4. Car Insurance-$100
  5. Food - $300
  6. Shopping - $100
  7. Misc - $100
  8. Travel - $100
  1. Total the expenditures and display it on the screen
  2. Calculate the difference between the income and expenditures and display it on the screen and name it Surplus/Deficit
  3. 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

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

Financial Audit American Battle Monuments Commissions Financial Statements For Fiscal Years 2011 And 2010

Authors: Government Accountability Office

1st Edition

1492310883, 978-1492310884

More Books

Students also viewed these Accounting questions

Question

(1 point) Calculate 3 sin x cos x dx.

Answered: 1 week ago

Question

Find the derivative of y= cos cos (x + 2x)

Answered: 1 week ago