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

please show me steps

thank you

is this the correct answer ??!

Home Draw Page Layout Formulas Data Review View Help Search KO A R D G M N Inland Jewelers 1 2 Date Cost Name 5 Dodson 6 Jones 7 Clarke 8 Ranger 9 McKinley 10 Broadhas 11 Burch 12 Totals 13 14 Ring Personalized Silver Yes Gold Yes Titanium No Platinum No Platinum Yes Gold No Titanium Yes Added Activity kon Yes No No No Yes Yes No Years Monthly Payment 1 1 2 3 3 2 3 Personalized Cost Personalized Plus Dulcon I 15 Ring Type Cost 16 Silver $ 400 00 17 Gold $ 550 00 18 Titanium $700.00 19 Platinum $ 750 00 20 Personalizing 5% 21 Surcharge 22 Interest Rate 39 23 Dual con $100.00 24 25 26 27 Classing Class Ring Additions ES =VLOOKUP(B5,SA$16:$D$19,IF(DS="Yes",4,IF(CS="Yes",3,2]}} B E F G H Inland Jewelers 1 2 Date 3 Ring Type Personalized Cost Yes Added Activity Icon Yes No No Yes Name 4 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 No No Yes No Yes Monthly Years Payment 1 $44.04 1 $48.91 2 $30.09 3 $21.81 3 $25.81 $29.12 3 $21.37 $221.15 520 577.5 700 750 887.5 677.5 735 4847.5 NO Yes Yes No 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 Classing ClassRing Additions Home Draw Page Layout Formulas Data Review View Help Search KO A R D G M N Inland Jewelers 1 2 Date Cost Name 5 Dodson 6 Jones 7 Clarke 8 Ranger 9 McKinley 10 Broadhas 11 Burch 12 Totals 13 14 Ring Personalized Silver Yes Gold Yes Titanium No Platinum No Platinum Yes Gold No Titanium Yes Added Activity kon Yes No No No Yes Yes No Years Monthly Payment 1 1 2 3 3 2 3 Personalized Cost Personalized Plus Dulcon I 15 Ring Type Cost 16 Silver $ 400 00 17 Gold $ 550 00 18 Titanium $700.00 19 Platinum $ 750 00 20 Personalizing 5% 21 Surcharge 22 Interest Rate 39 23 Dual con $100.00 24 25 26 27 Classing Class Ring Additions ES =VLOOKUP(B5,SA$16:$D$19,IF(DS="Yes",4,IF(CS="Yes",3,2]}} B E F G H Inland Jewelers 1 2 Date 3 Ring Type Personalized Cost Yes Added Activity Icon Yes No No Yes Name 4 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 No No Yes No Yes Monthly Years Payment 1 $44.04 1 $48.91 2 $30.09 3 $21.81 3 $25.81 $29.12 3 $21.37 $221.15 520 577.5 700 750 887.5 677.5 735 4847.5 NO Yes Yes No 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 Classing ClassRing Additions