Microsoft Excel Assignment $1$

Open e$02$h$1$Loans.xlsx and save as e$02$h$1$Loans$\_$LastFirst.xlsx$.$

Enter the formula $=B8-C8$ in cell D$8.$ Copy the formula from D$8$ to D$9$:D$12.$

Enter the formula $=E\frac{8}{\text{\$}}B$$$5$ in cell $F8.$ Copy the formula from F$8$ to F$9$:F$12.$

Enter the formula $=G8**B$$$5$ in cell $H8.$ Copy the formula from $H8$ to $H9$:$H12.$

Enter the formula $\frac{?}{S}=UM(B8$:$B12)$ in cell $B16.$

In cell B$17,$ enter the formula $=$AVERAGE$($B$8$:B$12).$

In cell B$18,$ enter the formula $=$MEDIAN$(B8$:$B12).$

In cell B$19,$ enter the formula $=$MIN$(B18$:$B12).$

In cell B$20,$ enter the formula $=$MAx$(B8$:$B12).$

In cell B$21,$ enter the formula $=$ COUNT$($B$8$:B$12).$

Copy the range $B16$:$B21$ to the range $C16$:$C21.$

Change the value of cell B$9$ to $425000.$

In cell $B4,$ enter the formula $=$ TODAY$().$

Format the cell $K8$ as Number with zero decimal places.

Copy the formula in cell $K8$ to the range $K9$:$K12.$

Save the document and submit based on your instructor's direction.