question archive Create a business budget sheet using Microsoft® Excel®
Create a business budget sheet using Microsoft® Excel®
Subject:BusinessPrice: Bought3
Create a business budget sheet using Microsoft® Excel®. In the budget sheet, do the following:
1)Create a label called "Income" and add your monthly business income in the next cell: $25,000.
2)Add a label called "Rent" and enter the amount in the next cell: -$4,000.
3)Add a label called "Utilities" and add the amount in the next cell: -$2,000.
4)Add a label called "Insurance" and add the amount in the next cell: -$500.
5)Add a label called "Product Development" and add the amount in the next cell: -$6,000.
6)Add a label called "Advertising" and add the amount in the next cell: -$2,000.
7)Add a label called "Customer Support" and add the amount in the next cell -$3,000
8)Use the SUM function to calculate the total for all the cells.
9)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
