Step Instructions Points Possible

$1$ Start Excel. Download and open the file named Exp$19\_$Excel$\_$Ch$02\_$Cap$\_$Appliances.xlsx$.$ Grader has automatically added your last name to the beginning of the filename. $0$

$2$ Insert a function in cell B$2$ to display the current date and time, and then format as a Long Date. $8$

$3$ Autofit the width of column B$.0$

$4$ Insert a function in cell C$5$ 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$.7$

$5$ AutoFit the width of column C$.0$

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

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

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

$9$ 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$.8$

$10$ Insert the function in cell H$5$ 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$.10$

$11$ Insert a function in cell H$14$ 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. $8$

$12$ Insert a function in cell H$18$ to calculate the total number of orders based on entries in column A$.6$

$13$ Insert a function in cell H$19$ to calculate the lowest monthly payment in column H$.6$

$14$ Insert a function in cell H$20$ to calculate the average monthly payment in column H$.6$

$15$ Insert a function in cell H$21$ to calculate the highest monthly payment in column H$.6$

$16$ Insert a function in cell H$22$ to calculate the median monthly payment in column H$.6$

$17$ Apply Currency Number Format with two decimal places to the range H$19$:H$22,$ if necessary. $2$

$18$ Insert a footer with your name on the left side, the sheet name in the center, and the file name on the right side. $6$

$19$ Save and close Exp$19\_$Excel$\_$Ch$02\_$Cap$\_$Appliances.xlsx$.$ Exit Excel. Submit the file as directed $0$