Use the ClassRing Additions worksheet to complete the following additional steps:

a. Enter a formula in cell C16 to calculate the cost of a silver ring with the additional

surcharge for personalization. (The silver ring would add $20, so the personalized cost

would be $420. Make your formula flexible and fill it down through cell C19.

b. Enter a formula in cell D16 to calculate the costs of personalizing the ring and adding a

second sports or activity icon (band, basketball, hockey, gymnastics, theater, etc.). The

original cost of the ring includes adding one activity icon to the side of the ring. If a

student wants to add a second icon, it costs an extra $100 dollars in addition to the

personalization cost. For the silver ring to be personalized with a dual icon, the total

cost would be $520. Make your formula flexible and fill it down through cell D19.

c. Add a new formula to cell E5 that will use a function to LOOK UP the appropriate price

for Dodson using the ring type, whether or not it is personalized, and whether or not

there is a second activity icon added to the ring. You will need to nest another function

with the lookup up function! Make your formula flexible and fill it down through cell

E12.

d. Calculate the monthly payment in cell G5 using the cost in E5 as the amount to finance.

Make your formula flexible and fill it down through cell G11.

e. Add the formulas for totals as indicated in row 12.

Save your completed workbook

......................

I want to make sure if my work is correct ??!

is there any mistake????

thank you

Calibri Accounting Pa Copy Format Painter 2 Wrap Text A FEE Merge & Center - BIU $. % * Conditional Form Formatting" Tab Clipboard Font Alignment Number B16 400 B C E F H G Monthly Payment Name Ring Type Personalized Cost Years 4 D Added Activity Icon Yes No No 5 Dodson 1 1 Yes Yes No No Yes 2 2 Silver Gold Titanium Platinum Platinum Gold Titanium No 3 Yes 6 Jones 7 Clarke 8 Ranger 9 McKinley 10 Broadnax 11 Burch 12 Totals 13 14 3 No Yes 2 3 Yes No Ring Type Cost Personalized Cost Personalized Plus Dual Icon 15 16 Silver 17 Gold 18 Titanium 19 Platinum 20 $ 400.00 $ 550.00 $ 700.00 $ 750.00 Personalizing Surcharge 5% 21 22 Interest Rate Dual Icon 3% $100.00 23 24 25 26 27 28 ClassRing ClassRing Additions ES =VLOOKUP(B5,$A$16:$D$19,IF(DS="Yes",4,IF(CS="Yes",3,2))) c D E F G H 1 1 Inland Jewelers 2 Date 3 Added Activity Name Ring Type Personalized Cost 4 Icon 5 Dodson 6 Jones 7 Clarke 8 Ranger 9 McKinley 10 Broadnax 11 Burch 12 Totals 13 14 Silver Gold Titanium Platinum Platinum Gold Titanium Yes Yes No No Yes Yes No No No Yes Yes No 520 577.5 700 750 887.5 677.5 735 4847.5 Monthly Years Payment 1 $44.04 1 $18.91 2 $30.09 3 $21.81 3 $25.81 2 $29.12 3 $21.37 $221.15 No Yes Ring Type 15 16 Gold 17 Platinum 18 Silver 19 Titanium 20 $ $ $ $ Personalized Personalized Cost Cost Plus Dual Icon 550.00 $ 577.50 $ 677.50 750.00 $ 787.50 $ 887.50 400.00 $ 420.00 $ 520.00 700.00 $ 735.00 $ 835.00 5% 3% $100.00 Personalizing 21 Surcharge 22 Interest Rate 23 Dual Icon 24 25 26 27 28 29 30 31 32 33 34 35 36 ClassRing ClassRing Additions Ready