EX/LZ/Al Microsoft Excel 2010-2 Assignment Please complete the assignment on time and submit it to the online portal. Also note that, late submissions will not be allowed. Duration: 1Hour. Marks -20 Mr. Jane wants you to create a new excel workbook for his computer company JCC Ltd. Name the workbook as New Price List.xls and save it on the desktop. Follow the instructions below: 1. Rename the first sheet 1 to Price List. 2. Merge the cell ranges A1: E1 and A2:E2 3. Insert WordArt in the first row that reads, \"JCC's Sales Price List\" 4. Using a formula insert todays date in cell F1 5. Insert the following Column Headings in row 4 0 Product ID Product Name Quantity Price Price Drop (Yes/No) O... 5. Enter the following data from row 5 l H0458 l Hard Drive 40068 l 187 l $225.00 H0258 Hard Drive 20068 134 $175.00 H0158 Hard Drive 10068 86 $125.00 DVD w1 DVD Writer 278 $90.00 DVD 61 DVD Combo $135.00 PRP236 Pentium Processor $335.00 6. Using the IF function, create a formula in cell E5 that enters the value of "No\" if the Quantity is less than 200 and, "Yes\" if it is Greater than 200. 7. Copy the above formula to cell range E6:E10 8. Copy the cell range A4:A10 and C4:C10 to Sheet2 9. Create a pie chart in SheetZ; using the data you copied. This chart should indicate the percentage of each product. Save your work on the Desktop