Creating a business budget sheet

Question

Assignment:

Question 1. 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.

1. Use the SUM function to calculate the total for all the cells.
2. Use the Freeze option to freeze the top panes.
3. Create a pie chart for your business income and spending.