Please answer in Google Sheets.

For each statement, identify the compounding period, the payment period, and the type of interest rate (nominal or effective), then express each rate as an effective annual, and monthly rate. a. 8% per year b. 2.5% per quarter 8.5% compounded monthly d. 6.8% quarterly, compounded monthly e. 2% per month, compounded weekly f. 1% per week c