Please help me out with the formulas in excel!

Q1 \& 2: Calculate solutions for problems 1 (Bond A) and 2 (Bond B) assuming annual compounding and again assuming semiannual compounding. Assume pricing on coupon dates, stated coupons are annual, and $100 FACE value. Bond A: 7.5s of 2038 (coupon and maturity) selling @ 109 3/8 (price); maturity 15 years. Bond B: 7.5s of 2053 selling @ 109 3/8; maturity 30 years \begin{tabular}{|l|l|l|l|l|} \hline & \multicolumn{2}{|c|}{ Bond A } & \multicolumn{2}{c|}{ Bond B } \\ \hline & Annual & Semiannual & Annual & Semiannual \\ \hline Coupon/period (\$) & & & & \\ \hline \# periods & & & & \\ \hline Price & & & & \\ \hline Current Yield & & & & \\ \hline YTM(BEY) & & & & \\ \hline YTM(effective) & & & & \\ \hline \end{tabular}