EX16XLCHOZGRADERCAPHW_-_Inland_Jewelers_112_Instructions - Protected View - Saved - levai Layout References Mailings Review View Help the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing Grader - Instructions Excel 2016 Project EX16_XL_CH02_GRADER_CAP_HW - Inland Jewelers 1.12 Project Description: You are an account manager for Inland Jewelers, a regional company that makes custom classnings for graduating seniors Your supervisor requested a workbook to report on new accounts created on payment plans. The report should provide details on total costs to the student as well as payment information Each ring financed has a base price that can fluctuate based on ring personalization Steps to Perform: Step Instructions Points Possible 1 1 Start Excel. Download and open the file named exploring_e02 grader h1 xlsx 0 2 Insert a function in cell B2 to display the current date from your system 10 3 With cell B2 selected, set the width of column B to AutoFit 2 4 Insert a VLOOKUP function in cell C5 to display the ring cost for the first student 5 Copy the formula from cell C5 to the range C6 C11 6. 6 Apply Accounting number format to the range C5 C11 3 7 14 Insert an IF function in cell E5 to calculate the total due if the student has chosen to personalize the nng, there is an additional charge of 5% located in cell B21 that must be applied, if not, the student only pays the base price. Use appropriate relative and absolute cell references 8 Copy the formula from cell E5 to the range E6 E11 6 9 Apply Accounting number format to the range E5 E11 3 10 14 Insert a function in cell G5 to calculate the first student's monthly payment using appropriate relative and absolute cell references 7 11 Can the formula from 5 to the rare G 11 D. Focus 199 O 9 W F12 F6 F4 F5 F7 F9 F10 F8 F11 EX16XLCHOZGRADERCAPHW_-_Inland_Jewelers_112_Instructions - Protected View - Saved - levai Layout References Mailings Review View Help the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing Grader - Instructions Excel 2016 Project EX16_XL_CH02_GRADER_CAP_HW - Inland Jewelers 1.12 Project Description: You are an account manager for Inland Jewelers, a regional company that makes custom classnings for graduating seniors Your supervisor requested a workbook to report on new accounts created on payment plans. The report should provide details on total costs to the student as well as payment information Each ring financed has a base price that can fluctuate based on ring personalization Steps to Perform: Step Instructions Points Possible 1 1 Start Excel. Download and open the file named exploring_e02 grader h1 xlsx 0 2 Insert a function in cell B2 to display the current date from your system 10 3 With cell B2 selected, set the width of column B to AutoFit 2 4 Insert a VLOOKUP function in cell C5 to display the ring cost for the first student 5 Copy the formula from cell C5 to the range C6 C11 6. 6 Apply Accounting number format to the range C5 C11 3 7 14 Insert an IF function in cell E5 to calculate the total due if the student has chosen to personalize the nng, there is an additional charge of 5% located in cell B21 that must be applied, if not, the student only pays the base price. Use appropriate relative and absolute cell references 8 Copy the formula from cell E5 to the range E6 E11 6 9 Apply Accounting number format to the range E5 E11 3 10 14 Insert a function in cell G5 to calculate the first student's monthly payment using appropriate relative and absolute cell references 7 11 Can the formula from 5 to the rare G 11 D. Focus 199 O 9 W F12 F6 F4 F5 F7 F9 F10 F8 F11