W$.$C$.$ Hicks Appliances

$1$

W$.$C$.$ Hicks Appliances

$4.$

Client Name

$5$

Garten

$6$

Leggett

$7$

Vong

$8$

Ranger

$9$

Williams

$10$ Davis

$11$ Jackson

$12$ Garcia

$13$ Broadnax

$14$ Totals

$15$

$16$

$17$

$18$

$19$

$20$

$21$

$22$

$23$

$24$

Inventory Information

SKU $294211$ Description

$294211$ Refrigerator

$306862$ Dishwasher

$327064$ Microwave

$446229$ Oven

$446741$ Washer

$643081$ Dryer

$25$ Delivery Fee

$25$ Interest Rate

$27$ Months Per Yeas

$28$

$29$

$30$

$31$

$32$

Insert a function in cell $C5$ to display the item named based on the provided inventory lookup information. Copy the function from cell C$5$ down through C$13$ to complete column C$.$

AutoFit the width of column $C.$

Insert a function in cell $E5$ to display the item price based on the provided inventory lookup information. Copy the function from cell E$5$ down through $E13$ to complete column $E.$

Apply Currency Number Format with two decimal places to column E$.$

Insert an IF function in cell F$5$ to calculate the total due. If the customer has chosen home delivery, there is an additional dellvery charge located in cell B$25.$ Be sure to use appropriate relative and absolute cell references.

Copy the function from cell F$5$ down through F$13$ to complete column F and apply Currency Number Format with two decimal places to column $F.$

Insert the function in cell $H5$ to calculate the first customer's monthly payment, using appropriate relative and absolute cell references. Ensure the result is a positive number. Copy the formula down to complete column $H.$

Insert a function in cell $H14$ to calculate the total of all monthly payments in column $H$ and apply Currency Number Format with two decimal places to column $H,$ if necessary.

Insert a function in cell $H18$ to calculate the total number of orders based on entries in column

A$.$

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

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

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

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