Orders for items W$-1,$ W$-2,$ W$-3,$ and W$-4$ receive a discount based on the quanity ofthe specific item being ordered. The Discounts worksheet provides the discountpercentage given the quantity of each item. $5.$ Use a single formula $($all parts of the formula in a single cell$)$ to populate E$2$:E$31$ with the appropriate discount percentage based on the item and quantity$\mathrm{.}6.$ Use formulas to populate F$2$:F$31$ with the order total. Hint: Order Total $=$ Sub Total $-($Discount $\%*$ Sub Total$)7.$ Use formulas to populate L$2$:L$5$ with the number of orders for each item$\mathrm{.}8.$ Use formulas to populate M$2$:M$5$ with the average quanity ordered for each item$\mathrm{.}9.$ Use formulas to populate N$2$:N$5$ with the total amount $($$$)$ ordered for each item.