Please show your work in excel and by calculator

You find the following Treasury bond quotes. To calculate the number of years until maturity, assume that it is currently May 2022 . All of the bonds have a par value of $1,000 and pay semiannual coupons. In the above table, find the Treasury bond that matures in May 2037 . What is the coupon rate for this bond? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g. 32.16