EX16_XL_CH02_GRADER_CAP_HW-Inland Jewlers
Answer key
EX16 XL CH02 GRADER CAP HW - Inland Jewelers 1.12 Project Description: You are an account manager for Inland Jewelers, a regional company graduating seniors. Your supervisor The report should provide details on total costs to the student as weli as has a base price that can fAuctuate based on ring personalization that makes custom class rings for created on payment plans payment information. Each rning financed requested a workbook to report on new accounts created on Instructions: For the purpose of grading the project you are required to perform the following tasks Step Instructions Start Excel. Download and open the file named exploring e02 grader hl.dsx 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 14 4 Insert a VLOOKUP function in cell C5 to display the ring cost for the first student 5 Copy the formula from cell CS to the range C6:c11. 6 Apply Accounting number format to the range C5:C11. insert an IF function in cell E5 to calculate the total due. If the student has chosen to 14 |personaize the ring, 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. 7 8 Copy the formula from cell ES to the range E6:E11 9 Apply Accounting number format to the range ES:E11. Insert a function in cell GS to calculate the first student's monthly payment, using appropriate relative and absolute cell references 14 Current Instruction EX16 XL CH02 GRADER CAP HW - Inland Jewelers 1.12 Project Description: You are an account manager for Inland Jewelers, a regional company graduating seniors. Your supervisor The report should provide details on total costs to the student as weli as has a base price that can fAuctuate based on ring personalization that makes custom class rings for created on payment plans payment information. Each rning financed requested a workbook to report on new accounts created on Instructions: For the purpose of grading the project you are required to perform the following tasks Step Instructions Start Excel. Download and open the file named exploring e02 grader hl.dsx 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 14 4 Insert a VLOOKUP function in cell C5 to display the ring cost for the first student 5 Copy the formula from cell CS to the range C6:c11. 6 Apply Accounting number format to the range C5:C11. insert an IF function in cell E5 to calculate the total due. If the student has chosen to 14 |personaize the ring, 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. 7 8 Copy the formula from cell ES to the range E6:E11 9 Apply Accounting number format to the range ES:E11. Insert a function in cell GS to calculate the first student's monthly payment, using appropriate relative and absolute cell references 14 Current Instruction