Preferably show how to do in excel

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. a. In the above table, find the Treasury bond that matures in May 2045. What is the asked price of this bond in dollars? Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. b. If the bid-ask spread for this bond is .0552 , what is the bid price in dollars? Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16