Start Excel. Download and open the file named Exp$22\_$Excel$\_$Ch$02\_$Cumulative$\_$Furniture$\_$Sales.xlsx$.$ Grader has automatically added your last name to the beginning of the filename. $0$

$2$ Insert a function in cell C$3$ to display the current date and ensure that the format is set as a Long Date. $4$

$3$ Set column C$$s width to Autofit. $0$

$4$ Insert a function in cell D$11$ to display the item name based on the provided inventory lookup information in the range B$24$:D$29.$ Be sure to use the appropriate absolute cell referencing and the function returns an exact match. Copy the function from cell D$11$ down through D$19$ to complete column D$.10$

$5$ Insert 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.2$

$21$ Save and close Exp$22\_$Excel$\_$Ch$02\_$Cumulative$\_$Furniture$\_$Sales.xlsx$.$ Exit Excel. Submit the file as directed