computer wk3-2

profileb.atkins

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: $25,000.
  • Add a label called "Rent" and enter the amount in the next cell: -$4,000.
  • Add a label called "Utilities" and add the amount in the next cell: -$2,000.
  • Add a label called "Insurance" and add the amount in the next cell: -$500.
  • Add a label called "Product Development" and add the amount in the next cell: -$6,000.
  • Add a label called "Advertising" and add the amount in the next cell: -$2,000.
  • Add a label called "Customer Support" and add the amount in the next cell -$3,000
  • 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.

    • 8 years ago
    • 10
    Answer(2)

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      business-budget.xlsx

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      business_budget_sheet.xlsx
    Bids(1)