| Excel File Edit View Insert Format Tools Data Window Help 100%-, Tue 5:10 PM a E solomon-Titman-Problem-5-16-Start a Search Sheet Home Insert Page Layout Formulas Data Review View + Share , xcopy, AutoSum Times New R 14 , A Ar TWrap Text Fil ,Clear S, %1,1% | conditional Format Cell Formatting as Table Styles | Insert Delete Format Paste B IUT -- Merge & Center, Sort & Filter Format Clear Center Text Kirk Van Houien, who bas been married fo 23 y, would like to buy his wife acxpensive diamond ring with a platinum setting on their 30-year wodding anmiversary, Assume that the cost of the ring will be $12,000 in severn yeara Kirk currenly has S4,510 to invest What anual rate of return must Kirk cainvestment to accumulale enough maney to pay for the ring Givea Dats: Cost of Ring afte 7 yeans Number of years from present to 30-year anniversary Money avilable for investing nor aol Interest Rute I ut which the mocey should be invested Stt Exoel In cell D10 by using cell references, calculate thke interet rate ut which the moey should be invested. Use the Excel RATE funotiun.Aume that all interest payments ure made at the end af the period, so omit the Itypel parameter Note: By default, all cell referen es re relative references. Do not use absolute cell reference. Do not eater any value for the Guess agumentof the Excel RATE furnction.(1 pt) Save the workbock. Cloe tho workbook and then exit Exal. Submit the woakbook as directed 5-16 + Enter 80% 6