Task Name: Phase 5 Individual Project Deliverable Length: Excel file with 1 worksheet Details: Weekly tasks or assignments (Individual or Group Projects) will be due by Monday, and late submissions will be assigned a late penalty in accordance with the l

Weekly tasks or assignments (Individual or Group Projects) will be due by Monday, and late submissions will be assigned a late penalty in accordance with the late penalty policy found in the syllabus. NOTE: All submission posting times are based on midnight Central Time.

Read the entire list of instructions before beginning the assignment.

Open a new blank Microsoft Excel Worksheet and complete the following steps to successfully finish and submit your assignment:

1. In the Microsoft Excel program, fill in data based on the table below. Make sure you start in Cell A1 (meaning “Season” is in Cell A1 and that “Fall” is in A5 and “Total” is in D1) 
   

   Season	Quantity	Price	Total
   Winter	1,500	$200.00	=B2*C2
   Spring	750	$175.00	=B3*C3
   Summer	500	$150.00	=B4*C4
   Fall	2,500	$225.00	=B5*C5

2. Type the numbers and formulas, and arrange them exactly as you see them within the table above.
3. Notice that the Formulas you typed in the Total Column are now the total cost of each season (Quantity x Price).
4. Select all four rows, Winter, Spring, Summer, Fall, along with the number for quantity and price.
5. Select the Insert tab, click on the Column icon, and select any chart type under “3-D Column.”
6. You should see that your total is a formula, not a number entered into the cell.
7. Save your Excel file as “yourname_IP4,” and send to your instructor for grading.