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.

Transcribed Image Text:

816 X Cut Copy Format Painter 13 14 Clipboard 4 5 Dodson 6 Jones 7 Clarke Name 8 Ranger 9 McKinley 10 Broadnax 11 Burch 12 Totals 27 28 Ring Type 15 16 Silver 17 Gold 18 Titanium 19 Platinum 20 Personalizing Surcharge 21 22 Interest Rate 23 Dual Icon 24 25 26 Calibri BIU- B Ring Type Silver Gold Font Cost $ 400.00 $ 550.00 $ 700.00 $ 750.00 5% Yes Titanium No Platinum No Platinum Yes Gold No Titanium Yes 400 3% $100.00 Personalized Yes 6.A. F Personalized Cost ClassRing ClassRing Additions Alignment D Added Activity Icon Yes No No No Yes Yes No Personalized Plus Dual Icon Wrap Text Merge & Center- E Cost G Accounting 5-%. Number Years 1 1 2 3 3 23 Conditional Form Formatting Tab Monthly Payment H 816 X Cut Copy Format Painter 13 14 Clipboard 4 5 Dodson 6 Jones 7 Clarke Name 8 Ranger 9 McKinley 10 Broadnax 11 Burch 12 Totals 27 28 Ring Type 15 16 Silver 17 Gold 18 Titanium 19 Platinum 20 Personalizing Surcharge 21 22 Interest Rate 23 Dual Icon 24 25 26 Calibri BIU- B Ring Type Silver Gold Font Cost $ 400.00 $ 550.00 $ 700.00 $ 750.00 5% Yes Titanium No Platinum No Platinum Yes Gold No Titanium Yes 400 3% $100.00 Personalized Yes 6.A. F Personalized Cost ClassRing ClassRing Additions Alignment D Added Activity Icon Yes No No No Yes Yes No Personalized Plus Dual Icon Wrap Text Merge & Center- E Cost G Accounting 5-%. Number Years 1 1 2 3 3 23 Conditional Form Formatting Tab Monthly Payment H

Answer rating: 100% (QA)

Here are the formulas to complete the additional step... View the full answer