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 eBusiness income in the next cell: $42,000 (adjust the monthly incomes so they are a little different each month).
• Add a label called "Rent" and enter the amount in the next cell: -$2,000.
• Add a label called "Product Spending" and enter the amount in the next cell: -$20,000 (change this by +$1,000 for each month).
• 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 (change this by +$75 for each month).
• Add a label called "Insurance" and add the amount in the next cell: -$500.
• Add a label called "Website hosting" and add the amount in the next cell: -$20.
• Add a label called "Cloud Storage" and add the amount in the next cell: -$10.
• Add a label called "Paypal Charges" and add the formula/function in the next cell: (cell contents MUST be a "function": 2% of the monthly income cell).
Create 2 charts (a chart for your business annual income and another chart for the annual expenses).
Formating:
- Header: Enter title, student name.
- Footer: Enter Page #, date.
- Set borders around the cells you enter data into.
- Set the page settings (Page layout, Print Area, Margins, Size, etc.). Everything must print on 1 sheet of paper in landscape (review print preview).