#7 Insert an IF function in cell E5 to calculate the total due. If the student has chosen to personalize the ring, there is an additional charge of 5% located in B21 that must be applied; if not, the student only pays the basic price. Use appropriate relative and absolute cell references. Copy formula from E5 to the range E6:E11

#10 insert a function is cell G5 to calculate the first months student monthly payment, using appropriate relative and absolute cell references. Copy the formula from cell G5 to the range G6:G11.

Financial . Ev .? More Fu Name Manager Create from Selection Defined Names Date & Time E5 Inland Jewelers 2 Date 17/2018 Monthly Payment 5 Dodson 6 Jones 7 Clarke Ring TypeCost Personalized TotalYears Silver$400.00 Yes Gold$550.00 Yes Titanium $700.00 No 8 9 McKinley Platinum $750.00 Yes 10 Broadnax 11 Burch 12 Totals 13 14 Ranger Platinum $ 750.00 No Gold $550.00 No Titanium $ 700.00 Yes Cost 400.00 550.00 16 Silver 17 Gold 18 Titanium $ 700.00 19 Platinum$750.00 20 5% 396 | 21 | Surcharge ol 22 Interest Rate 24 26 27 29 32