Createnbspa business budget sheet using

Question

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.

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

Answer 1

The specified assignments below you have to work on it and show a chart of business Generate a business budget sheet using Microsoft Excel. In the budget sheet do the subsequent: Generate a label called ‘Income’ and add your monthly business income in the next cell: $42000. • Add a label said "Rent" and enter the amount in the next cell: -$2000. • Add a label said "Product Spending" and enter the amount in the next cell: -$20000. • Add a label said "Gas" and add the amount in the next cell: -$250. • Add a label said "Car Payment" and add the amount in the next cell: -$500. • Add a label said "Electric" and add the amount in the next cell: -$600. • Add a label said "Insurance" and add the amount in the next cell: -$500. Employ the SUM function to compute the total for all the cells. Employ the Freeze option to freeze the top panes. Generate a pie chart for your business income and spending.