these are the steps please help
Exer 2.2. Y 100% Layout Tables Charts SmartArt Formulas Data Review Fant Number Format Alignment abc FRI Calibri (Body) A- A- Wrap Text General Normal 1 U Clear 2 % Bad Merge ES Conditional Formatting fx Adapted from 2017 Pearson Microsoft Office 2016 V.1 Grauer D H c M N P Custom Jewelers Custom Jewelers makes custom class rings for graduating seniors. As an accounting manager you want to create a workbook to report details on total costs to the student as well as payment Information. Eaching financed has a base price plus ring personlization 1. The "Class Fog Raw Data tab" contains all of the information to complete the exercise. Creat a copy of this worksheet and label it "Class Ring Completed. All of your work should be completed in the Completed tab 2. In cell 2 insert a function to display the current date and format it as a Long Date 3. Set 8' width to Autofit. You will calculate the cost of each dass eine ordered. The rings are priced based on their base metal displayed in the range A1-819 Insert a Vlookup function in cell cs to display the ring cost for the first student. 5.Copy the function from cells down through C11 to complete column cure the appropriate cells are locked or else the formula will not autol properly. Glance over the information that has been filled in range CS to 011 to ensure it appropriately corresponds with buse metal displayed in the range A15 B19. You will calculate the total due for each student's order. The total is the base price of the ring plus an additional charge for personalization if applicable 6. Insert en ef function in cells to calculate the total due the nudent has chosen to personlize the ring (as indicated in column D), there is an additional charge of ex located in cel 021 that must be applied, not, the student only pays the base price. Note that when entering text in your formulation you must put quotation marks before and after it (lei) se appropriate relative and absolute cell references. 7. Copy the function from cell down through 11. The next steps to calulate the periodic payment for each student's account. The payments are based on the years financed in column and the annual interest rate in cell 022. All accounts are paid on a monthly basis. 8. Insert PME function in cell to calculate the first student's monthly payment, using appropriate relative and absolute coil reference, more that will information is provided monthly under "Monthly Payment as the interest rate and the year financed are provided in a yearly format 9. Copy the formula down the column 10. Calculate the total in cell C12, E12, and 612 11. Apply the accounting number format to decimal places for column, and 12. In cels CAZ, 117, and 612 apply a "Top and Double Bottom Border for the total 13. In cell G16 apply a statistical function calculating the average monthly payment Per Customer for Inland Jewiers. Instructions Class King Raw Data Steps 1-3 1. Work has been completed in the "Class Ring Completed" worksheet. 2. In cell B2 a function has bee used to display the current date and formatted as a "Long Date. 13. Column B's width is set to Autofit. Steps 4-5 4-5. A Vlookup function has been inserted in cell C5 to display the ring cost for the first student. It has been copied down from cell C5:C11 with no error message displayed as the appropriate cells have been locked. Steps 6-7 6. An IF function has been entered in cell ES to calculate the total due with no error messages as appropriate relative and absolute cell references have been used. The function has been copied down from cell E5:E11. N Steps 8-9 8-9. A PMT function has been entered in cell G5 in a monthly format to calculate the first student's monthly payment, using appropriate relative and absolute cell reference and copied down. F M Steps 10-12 10. The total has been calculate for cell c1 E12, and G12. 11. The accounting number format has been applied to decimal places for column CE. and G 12. Cells C12, E12, and G12 "Top and Double Bottom Border" applied. Steps 13-17 13-16. Appropriate statistical functions applied to Cell G16 G19 17. Your last and first name have been entered at the end of the file name. 15 Fu M
