Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.

QUESTION

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

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question