(Solved): \( 9 \quad \) On the Transactions worksheet, in cell H10, replace the static value by entering a V ...

\( 9 \quad \) On the Transactions worksheet, in cell H10, replace the static value by entering a VLOOKUP \( 1.5 \) function to retrieve the Item's price from the Products.dist table and then multiply it by the quantity to calculate the gross revenue. Use the fill handle to copy the formula down through \( \mathrm{H} 30 \). 10 On the Transactions worksheet, in cell J10, replace the static value by entering a HLOOKUP \( 1.5 \) 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 \( \mathrm{J} 30 \).