Exp$19\_$Excel$\_$Ch$02\_$CapAssessment$\_$Inland$\_$Jewelers

Project Description:

You are an account manager for Inland Jewelers, a regional company that makes custorn class rings for graduating s Your supervisor requested a workbook to report on new accounts created on payment plans. The report should provic on total costs to the student as well as payment information. Each ring financed has a base price that can fluctuate ba ring personalization.

Steps to Perform:

$\backslash$table$[[$Step$,$Instructions$],[1,\backslash$table$[[$Start Excel. Download and open the file named Exp$19\_$Excel$\_$Ch$02\_$Cap$\_$InlandJewelers.xIsx.$],[$Grader has automatically added your last name to the beginning of the filename.$]]],[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,\backslash$table$[[$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 $C5$ to the range $C6$:$C11.],[6,$Apply Accounting number format to the range $CC_{11}.],[7,\backslash$table$[[$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,\backslash$table$[[$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]]$