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
Sun | Mon | Tue | Wed | Thu | Fri | Sat |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | 6 | 7 |
8 | 9 | 10 | 11 | 12 | 13 | 14 |
15 | 16 | 17 | 18 | 19 | 20 | 21 |
22 | 23 | 24 | 25 | 26 | 27 | 28 |
29 | 30 | 1 | 2 | 3 | 4 | 5 |