Assignment -
Prepare a Microsoft Excel spreadsheet saved under the following naming convention: LastnameFirstnameW3-1. Using student John Doe as an example: DoeJohnW3-1. The spreadsheet must contain the following:
Cell Values, Formula Contents and Charts:
Row 1: Enter text "Business Budget"
Row 2: Enter text "Income", and enter the number 25000 in the next cell
Row 3: Enter text "Rent", and enter the number -4000 in the next cell
Row 4: Enter text "Utilities", and enter the number -2000 in the next cell
Row 5: Enter text "Insurance", and enter the number -500 in the next cell
Row 6: Enter text "Advertising", and enter the number -2000 in the next cell
Row 7: Enter text "Product Development", and enter the number -600 in the next cell
Row 8: Enter text "Net Amount", and use the SUM function in the next cell to calculate the total for all the values
Row 9: Enter text "Avg Expense Amt", and use the AVERAGE function in the next cell to calculate the average for all the expenses
Use the Freeze Panes option to freeze only Row 1.
Insert a Pie Chart that displays only the Income in Row 2, and each Expense in Rows 3-7.