Creating a business budget sheet


Assignment:

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.

Solution Preview :

Prepared by a verified Expert
Business Management: Creating a business budget sheet
Reference No:- TGS01798916

Now Priced at $40 (50% Discount)

Recommended (94%)

Rated (4.6/5)