nsert a function in cell F$11$ to display the item price based on the provided inventory lookup information. Be sure to use appropriate absolute cell referencing and the function returns an exact match. Copy the function from cell F$11$ down through F$19$ to complete column F$.$

$10$

$6$

Apply Currency Format to column F$.$

$5$

$7$

Insert an IF function in cell G$11$ to calculate the total due. If the customer has chosen delivery $($column E $=$ Yes$),$ there is an additional delivery charge located in cell L$11.$ If the item is not delivered, the total due is price. Be sure to use appropriate relative and absolute cell references. Copy the function from cell G$11$ down through G$19$ to complete column G$.$

$10$

$8$

Apply Currency format to column G$.$

$5$

$9$

Insert the function in cell I$11$ to calculate the first customer$$s monthly payment, using appropriate relative and absolute cell references. Place a minus sign to the left of the present value argument so that the function returns a positive result. Copy the formula down the column.

$10$

$10$

Use Quick Analysis to insert a function in cell I$20$ that calculates the total of all monthly payments in column I.

$4$

$11$

Apply Currency Format to column I.

$5$

$12$

Type the customer name McGowan in cell B$6.$

$2$

$13$

Use the XLOOKUP function in cell C$6$ to lookup the customer name in the worksheet and return the corresponding SKU, item name, delivery option, price, total due, years financed, and monthly payment.

$9$

$14$

Use Format Painter to copy the format from the range C$11$:I$11$ to C$6$:I$6.$

$3$

$15$

Insert a function in cell H$24$ to calculate the total number of orders in the SKU column.

$5$

$16$

Insert a function in cell H$25$ to calculate the lowest monthly payment in column I.

$4$

$17$

Insert a function in cell H$26$ to calculate the average monthly payment in column I.

$4$

$18$

Insert a function in cell H$27$ to calculate the highest monthly payment in column I.

$4$

$19$

Insert a function in cell H$28$ to calculate the median monthly payment in column I.

$4$

$20$

Apply Currency format to the range H$25$:H$28.$