Custom Jewelers

information. Each ring financed has a base price plus ring personlization.

completed in the Completed tab.

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

Set B$\text{'}$s width to Autofit.

You will calculate the cost of each class ring ordered. The rings are priced based on their base metal displayed in the range A$15$:B$19.$

Insert a Vlookup function in cell C$5$ to display the ring cost for the first student.

that has been filled in range C$5$ to C$11$ to ensure it appropriately corresponds with base metal displayed in the range A$15$:B$19.$

You will calculate the total due for each student's order. The total is the base price of the ring plus an additional charge for personalization if applicable.

appropriate relative and absolute cell references.

Copy the function from cell E$5$ down through E$11.$

are paid on a monthly basis.

under "Monthly Payment" as the interest rate and the years financed are provided in a yearly format.

Copy the formula down the column.

Calculate the total in cell $C12,E12,$ and $G12.$

Apply the accounting number format to decimal places for column C$,$ E$,$ and G$.$

In cells C$12,$ E$12,$ and G$12$ apply a "Top and Double Bottom Border" for the totals.

In cell G$16$ apply a statistical function calculating the average monthly payment Per Customer for Inland Jewlers.

In cell G$17$ apply a statistical function calculating the minimum monthly payment Per Customer for Inland Jewlers.

In cell G$18$ apply a statistical function calculating the maximum monthly payment Per Customer for Inland Jewlers.

In cell G$19$ apply a statistical function calculating the median monthly payment Per Customer for Inland Jewlers.

Save your file and insert your last and first name at the end of the file name. Submit your completed file to your instructor.