Create a business budget sheet using Microsoft® Excel®. In the budget sheet do the following:

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.

Click the Assignment Files tab to submit your assignment.

Purpose of Assignment

The Business Budget assignment is designed to give students the opportunity to use Microsoft Excel by providing a scenario that illustrates specific and realistic uses for the information such as the SUM function, cells, freezing, and so forth.

Content
70 Percent Met
Partially Met Not Met
The spreadsheet includes a cell labeled “Income” and a cell next to it with the amount: \$42000.
The spreadsheet includes a cell labeled “Rent” and a cell next to it with the amount:
-\$2000.
The spreadsheet includes a cell labeled “Product Spending” and a cell next to it with the amount: -\$20000.
The spreadsheet includes a cell labeled “Gas” and a cell next to it with the amount: -\$250.
The spreadsheet includes a cell labeled “Car Payment” and a cell next to it with the amount: -\$500.
The spreadsheet includes a cell labeled “Electric” and a cell next to it with the amount: -\$600.
The spreadsheet includes a cell labeled “Insurance” and a cell next to it with the amount: -\$500.
The SUM function is applied correctly and the amount reflected should be \$18150.
The spreadsheet has the Freeze option applied correctly to the top panes.
The spreadsheet includes a pie chart for the income and spending that correctly reflects the figures entered.