B2 fx A B D E F G H 2 Date 3 Name Ring Type Cost Personalized Total Years Monthly Payment 4 Yes Yes No 5 Dodson 6 Jones 7 Clarke 8 Ranger 9 McKinley 10 Broadnax 11 Burch 12 Totals Silver Gold Titanium Platinum Platinum Gold Titanium No W NW W NPP Yes No Yes 13 14 15 Ring Type 16 Silver 17 Gold 18 Titanium 19 Platinum 20 Cost $ 400.00 $ 550.00 $ 700.00 $ 750.00 Personalizing Surcharge 5% 21 22 Interest Rate 3% 23 24 25 26 27 28 29 30 ClassRing Edit Accessibility: Investigate + E + 100% Assignment Instructions Step Instructions Point Value 1 0 Start Excel. Download and open the file named Exp19_Excel_Ch02_Cap_InlandJewelers.xlsx. Grader has automatically added your last name to the beginning of the filename. 2 10 Insert a function in cell B2 to display the current date from your system. 3 With cell B2 selected, set the width of column B to AutoFit. 0 4 14 Insert a VLOOKUP function in cell C5 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 6 Apply Accounting number format to the range C5:C11. 4 7 14 Insert an IF function in cell E5 to calculate the total due. If the student has chosen to personalize the ring, there is an additional charge of 5% located in cell B21 that must be added to the cost of the ring; if not, the student only pays the base price. Use appropriate Close