$(1)$ Use the indicated periods and periodic rates to correctly fill in the yellow cells in rows $7,8$ and $9.$ Be sure to use cell references for the APR and EAR and round all percentage answers to two places after the decimal point.

$\backslash$table$[[$PERIOD$,$DAILY,WEEKLY,MONTHLY,QUARTERLY,SEMIANNUAL,ANNUAL,$],[$PERIODIC RATE,$0\mathrm{.}03\%,0\mathrm{.}15\%,0\mathrm{.}75\%,2\mathrm{.}50\%,7\mathrm{.}50\%,8\mathrm{.}25\%,],[$TIMES COMPOUNDED PER YEAR,,,,,,,$],[$ANNUAL PERCENTAGE RATE $($APR$),,,,,,,],[$EFFECTIVE ANNUAL RATE $($EAR$),,,,,,,],[$EFFECTIVE ANNUAL RATE $($EAR$),,,,,,($Please solve this with excel and provide correct formulas to plug into the yellow boxes. Thank you$)$