Insert an IF function in cell E5 to calculate the total due. Use appropriate relative and absolute cell references.Ĭopy the formula from cell C5 to the range C6:C11.Īpply Accounting number format to the range C5:C11. The cost of the ring type should be an exact match. Insert a VLOOKUP function in cell C5 to display the ring cost for the first student. With cell B2 selected, set the width of column B to AutoFit. Insert a function in cell B2 to display the current date from your system. Grader has automatically added your last name to the beginning of the filename. Download and open the file named Exp19_Excel_Ch02_Cap_InlandJewelers.xlsx. Each ring financed has a base price that can fluctuate based on ring personalization. The report should provide details on total costs to the student as well as payment information. Your supervisor requested a workbook to report on new accounts created on payment plans. You are an account manager for Inland Jewelers, a regional company that makes custom class rings for graduating seniors. Exp19_Excel_Ch02_CapAssessment_Inland_JewelersĮxp19 Excel Ch02 CapAssessment Inland Jewelers Project Description:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |