need help asap!!!! PLEASE SHOW ME THE EXCEL FUNCTION.

Joon-won is trying to solve the following question using the Excel. Please check it out and correct anything wrong for the right answer. Parkway Void Co. issued 20-year bonds two years ago at a coupon rate of 5.4 percent. The bonds make quarterly payments. If these bonds curreritly sell for 106 percent of par value, what is the YTM and EAR? Double click the below and open it. Relative to Bond C, for a 200 bp increase in the required rate of return, Bond B will most likely exhibit a( n) : Answer: [ B ] A. equal percentage price change. B. greater percentage price change. C. smaller percentage price change. 6-2. Which bond will most likely experience the smallest percentage change in price if the market discount rates fo all three bonds increase by ioo bps? Answer: A. Bond A B. Bond B C. Bond C Joon-won is trying to solve the following question using the Excel. Please check it out and correct anything wrong for the right answer. Parkway Void Co. issued 20-year bonds two years ago at a coupon rate of 5.4 percent. The bonds make quarterly payments. If these bonds curreritly sell for 106 percent of par value, what is the YTM and EAR? Double click the below and open it. Relative to Bond C, for a 200 bp increase in the required rate of return, Bond B will most likely exhibit a( n) : Answer: [ B ] A. equal percentage price change. B. greater percentage price change. C. smaller percentage price change. 6-2. Which bond will most likely experience the smallest percentage change in price if the market discount rates fo all three bonds increase by ioo bps? Answer: A. Bond A B. Bond B C. Bond C