To ensure proper documentation, you will insert the current date into the worksheet.

$1.$ Open the Exc$2$Appliances.xlsx workbook and save it as Exc$2$Appliances$\_$LastFirst.xlsx$.$

$2.$ Insert a function in cell B$2$ to display the current date and format it as a Long Date.

$3.$ Set column B$$s width to Autofit.

Create Item Name and Price Lookups

Your first task is to use a lookup function based on the data in the range A$18$:C$23$ to determine the name of the item purchased and the corresponding price based on the provided SKU number.

$4.$ Insert a function in cell C$5$ to display the item name based on the provided inventory lookup information.

$5.$ Copy the function from cell C$5$ down through C$13$ to complete column C$.$

$6.$ Set column C$$s width to $12\mathrm{.}5.$

$7.$ Insert a function in cell E$5$ to display the item price based on the provided inventory lookup information.

$8.$ Copy the function from cell E$5$ down through E$13$ to complete column E$.$

Determine Delivery Fee

You will calculate the total due for each customer$$s order. The total is the purchase price plus an optional delivery charge.

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

$10.$ Copy the function from cell F$5$ down through F$13$ to complete column F$.$

$11.$ Insert a function in cell F$14$ to calculate the total due for all orders in column F$.$

Calculate the Monthly Payment