nsert a function in cell b$2$ to display the current date from your system

Question: $2$ Insert a function in cell B$2$ to display the current date from your system. $3$

$2$

Insert a function in cell B$2$ to display the current date from your system.

$3$

With cell B$2$ selected, set the width of column B to AutoFit.

$4$

Insert a VLOOKUP function in cell C$5$ to display the ring cost for the first student. The cost of the ring type should be an exact match. Use appropriate relative and absolute cell references.

$5$

Copy the formula from cell C$5$ to the range C$6$:C$11.$

$6$

Apply Accounting number format to the range C$5$:C$11.$

$7$

Insert an IF function in cell E$5$ to calculate the total due. If the student has chosen to personalize the ring, there is an additional charge of $5\%$ located in cell B$21$ that must be added to the cost of the ring; if not, the student only pays the base price. Use appropriate relative and absolute cell references.

$8$

Copy the formula from cell E$5$ to the range E$6$:E$11.$

$9$

Apply Accounting number format to the range E$5$:E$11.$

$10$

Insert a function in cell G$5$ to calculate the first student's monthly payment, using appropriate relative and absolute cell references. Ensure the result is a positive number.

$11$

Copy the formula from cell G$5$ to the range G$6$:G$11.$

$12$

Apply Accounting number format to the range G$5$:G$11.$

$13$

Calculate totals in cells C$12,$ E$12,$ and G$12.$

$14$

Apply Accounting number format to the cells C$12,$ E$12,$ and G$12.$

$15$