Please do this ONLY if you can tell me exactly what formulas to put in each cell using the instructions and excel workbook below.

Use the formula Assignment workbook for this assignment [Set up the appropriate formulas in the green cells] You are trying to set up an Excel spreadsheet to track customer orders for a company- There are a few things you need to complete: (a) Create defined names for selected cells in the Policy worksheet You need to use the suggested names given in the Policy worksheet. (b) Determine the appropriate price based on quantity ordered Use appropriate function(s) to set up a formula to look up, for each customer, the price in the Price Table using the quantity ordered. (c) Determine the overall sales Set up a formula to calculate the overall sales, which is quantity ordered multiplied by price. (d) Determine the final sales Customers will receive a 15% discount if they received a coupon and are also members of the reward program. Customers will only recelve a 10% discount if they only received a coupon or are members of the reward program. No discount will be provided otherwise. Use appropriate function(s) to set up a formula to determine each customer's final sales. (e) Determine the shipping Customers will get free shipping if their final sales are $400 or more. Otherwise, they will pay $0.50 per unit for shipping. Use appropriate function(s) to set up a formula to determine each customer's shipping. (f) Determine the total paid Set up a formula to calculate the total paid by each customer, which is the sum of the final sales and shipping. Item to submit: (n)