Need the Excel functions for part C.

After recently receiving a bonus, you have decided to add some bonds to your investment portfolio. You have narrowed your choice down to the following bonds (assume semiannual payments): C. Which bond would you rather own if you expect market rates to fall by 2% across the maturity spectrum? What if rates will rise by 2%? Why? Show your formulas and answers in the excel sheet