how do i find the price for IBM coupon bond and the coupon rate for AOL coupon bond using excel?

Missing information on a bond. Your broker faxed to you the following information abou bonds that you are considering as a potential investment. Unfortunately, your fax machin the items, and all you can read from the fax on the two different bonds is the following: Data table (Click on the following icon 2 in order to copy its contents into a spreadsheet)