$14$ You want to lookup the cost of each membership based on the type.

In cell C$5,$ insert a VLOOKUP function using the membership in column B and the look up information in A$17$:C$20$ to find the cost. Copy the function through the range C$5$:C$13.7$

$15$ You want to find the annual membership total.

In E$5,$ insert a logical function that will show the annual membership total. If the member has a locker, the Annual Total will be the Cost plus the Locker Fee. If the member doesn't have a locker, the Annual Total will be the Cost. Copy the function down through range E$5$:E$13.7$

$16$ You want to calculate the total membership.

In G$5,$ insert a formula to calculate the total by multiplying the Annual Total by the Years. Copy this formula through the range G$5$:G$13.2$

$17$ You want to lookup the down payment.

In H$5,$ insert a XLOOKUP function to lookup the down payment using the membership in column B and the look up information in A$17$:A$20.$ Copy the function down through H$5$:H$13.7$

$18$ You want to calculate the balance for the loan.

In I$5,$ insert a formula to calculate the balance by subtracting the Down Payment from the Total Due. Copy the formula down through I$5$:I$13.2$

$19$ You want to calculate the monthly payment for the loan.

In J$5,$ use the payment function to calculate the total monthly payment. Use the Interest Rate and the Months Per Year found in B$23$ and B$24.$ Ensure the results are positive values then use the fill handle to copy the function down through J$13.7$

$20$ You want to perform some summary statistics.

In G$18,$ enter a function to count the members in column A$.$

In G$19,$ enter a function to calculate the lowest Monthly Payment.

In G$20,$ enter a function to calculate the average Monthly Payment.

In G$21,$ enter a function to calculate the highest Monthly Payment.

In G$22,$ enter a function to calculate the median Monthly Payment.

In G$23,$ enter a function to calculate the sum of the Total Due. $3\mathrm{.}2$