business budget excel spreadsheet

Prepare a Microsoft® Excel® spreadsheet saved under the following naming convention:  LastnameFirstnameW3-2.  Using student John Doe as an example: DoeJohnW3-2.  The requirements of this assignment are as follows:

*  Row 1:  Add a label called “Business Budget”

*  Row 2:  Add a label called “Income” and enter $25000 in the next cell

*  Row 3:  Add a label called “Rent” and enter -$4000 in the next cell

*  Row 4:  Add a label called “Utilities” and enter -$2000 in the next cell

*  Row 5:  Add a label called “Insurance” and enter -$500 in the next cell

*  Row 6:  Add a label called “Product Development” and enter -$6000 in the next cell

*  Row 7:  Add a label called “Advertising” and enter -$2000 in the next cell

*  Row 8:  Add a label called “Customer Support” and enter -$3000 in the next cell

*  Use the SUM function to calculate the total for all the cells

*  Use the Freeze Panes option to freeze Row 1

*  Insert a Pie Chart that displays the Income and Expenses

Posted in Uncategorized