Aleeta would like to reward certain customers with a prize based on the total amount spent and total quantity of items purchased. On the Transactions worksheet, in cell C33, use the LET function to add clarity to a formula that evaluates each customer's total amount spent and total quantity of items purchased, using the sample transaction data provided, and returns Prize if they meet both criteria identified in cells F33:G33. If|a customer doesn't meet the criteria, return a blank ("'"). Use the following variable names in the function: TotalSpent and TotalQty Copy the formula down to C42. On the Transactions worksheet, in cell I10, replace the static value by entering a VLOOKUP function to retrieve the Item's price from the Product_List table and then multiply it by the quantity to calculate the gross revenue. Use the fill handle to copy the formula down through 130 On the Transactions worksheet, in cell K10, replace the static value by entering a HLOOKUP function to retrieve the discount value from the range B4:D6 based on the coupon code used in the transaction. Use the fill handle to copy the formula down through K30. Transaction Analysis Product List Aleeta would like to reward certain customers with a prize based on the total amount spent and total quantity of items purchased. On the Transactions worksheet, in cell C33, use the LET function to add clarity to a formula that evaluates each customer's total amount spent and total quantity of items purchased, using the sample transaction data provided, and returns Prize if they meet both criteria identified in cells F33:G33. If|a customer doesn't meet the criteria, return a blank ("'"). Use the following variable names in the function: TotalSpent and TotalQty Copy the formula down to C42. On the Transactions worksheet, in cell I10, replace the static value by entering a VLOOKUP function to retrieve the Item's price from the Product_List table and then multiply it by the quantity to calculate the gross revenue. Use the fill handle to copy the formula down through 130 On the Transactions worksheet, in cell K10, replace the static value by entering a HLOOKUP function to retrieve the discount value from the range B4:D6 based on the coupon code used in the transaction. Use the fill handle to copy the formula down through K30. Transaction Analysis Product List