Can someone show me how to work these out in excel, please?

Jan's $1,000 face value coupon bond will pay 4 percent interest annually for 12 years. What is the percentage change in the price of this bond if the market yield rises to 6 percent from the current level of 5.5 percent? A- -5.28, B 4.13, C- -2.38, D- -4.41, E- 1.13

Sue's zero coupon bond with a face value of $1,000 is issued with an initial price of $430.84 based on semiannual compounding. The bond matures in 25 years. What is the implicit interest, in dollars, for the first year of the bond's life? A- 19.08, B- 21.47, C- 22.56, D- 25.25, E- 14.76