Show this step by step in excel sheet

In this exercise we practice going from spot to par and from swap to spot.

$1.$ In one economy, spot yields are $3,4,5,$ and $6$ percent $($per annum, with S$/$A

compounding$)$ at tenors $6,12,18,$ and $24$ months. What are par yields at those

same tenors?

$2.$ In a different economy, swap rates are $3,4,5,$ and $6$ percent $($per annum, with

S$/$A compounding$)$ at tenors $6,12,18,$ and $24$ months. What are spot yields at

those same tenors?