due in 48 hours . NOOO PLAGIARIM!!!!!!

profileoenydocilliams

Create a business budget sheet using Microsoft® Excel®. In the budget sheet do the following:

  • Create a label called "Income" and add your monthly business income in the next cell: $42000.
  • Add a label called "Rent" and enter the amount in the next cell: -$2000.
  • Add a label called "Product Spending" and enter the amount in the next cell: -$20000.
  • Add a label called "Gas" and add the amount in the next cell: -$250.
  • Add a label called "Car Payment" and add the amount in the next cell: -$500.
  • Add a label called "Electric" and add the amount in the next cell: -$600.
  • Add a label called "Insurance" and add the amount in the next cell: -$500.

HINT:  Please be sure your total is correct and please pay attention to currency symbols/cell formatting. 

 

Use the SUM function to calculate the total for all the cells.

Use the Freeze option to freeze the top panes.

Create a pie chart for your business income and spending.

Save this document as Lastname_BusinessBudget_W3.xls

Click the Assignment Files tab to submit your assignment.

Do Not submit any other file(s) aside from ONE Excel spreadsheet

 
    • 8 years ago
    • 7
    Answer(3)

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      lastname_businessbudget_w3.xlsx

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      businessbudget.xlsx

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      business_budget_sheet.xlsx