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.

please show me the steps

thank you

the cost column

$ 400.00

$ 550.00

$ 700.00

$ 750.00

B E F G H 1 Inland Jewelers 2 Date 3 Name Added Activity 4 Ring Type Personalized Cost Years Icon Monthly Payment Yes 1 Silver Yes Gold Yes Titanium No Platinum No Platinum Yes Gold No Titanium Yes No No No 5 Dodson 6 Jones 7 Clarke 8 Ranger 9 McKinley 10 Broadnax 11 Burch 12 Totals 13 14 1 2 3 Yes Yes No 3 2 3 Cost Personalized Cost Personalized Plus Dual Icon Ring Type 15 16 Silver 17 Gold 18 Titanium 19 Platinum 20 Personalizing Surcharge 5% 21 22 23 24 Interest Rate Dual Icon 3% $100.00 Classing ClassRing Additions Ready B E F G H 1 Inland Jewelers 2 Date 3 Name Added Activity 4 Ring Type Personalized Cost Years Icon Monthly Payment Yes 1 Silver Yes Gold Yes Titanium No Platinum No Platinum Yes Gold No Titanium Yes No No No 5 Dodson 6 Jones 7 Clarke 8 Ranger 9 McKinley 10 Broadnax 11 Burch 12 Totals 13 14 1 2 3 Yes Yes No 3 2 3 Cost Personalized Cost Personalized Plus Dual Icon Ring Type 15 16 Silver 17 Gold 18 Titanium 19 Platinum 20 Personalizing Surcharge 5% 21 22 23 24 Interest Rate Dual Icon 3% $100.00 Classing ClassRing Additions Ready