Please use excel functions to solve answers provided below

Please use exact cell numbers to solve

with dollar amounts or percentages as Currency or Percentage, respectively. #2 Use the NOMINAL function to convert the effective annual return in cell C5 to an APR. Be sure your formula links to cell C7 since the compounding frequency must match the savings frequency. #3 Use the NOMINAL function to convert the effective annual return in cell C6 to an APR. Be sure your formula links to cell C 7 since the compounding frequency must match the savings frequency. #4 Use the FV function to calculate how much Dalia will have in savings when she gets to retirement. #5 Use the PMT function to calculate how much Dalia can spend each period while in retirement (use the same number of periods in a year as specified in cell c7). #6 Calculate the amount she will have at retirement (cell c11) if she already has $35,000 in her retirement account. Hint: this is easiest to do by using the optional [pv] argument in the FV function. #7 Use the PMT function to calculate the amount she can spend each period in retirement given the amount you calculate cell 1616 . #8 Dalia would like to have $2,000,000 in her account at retirement. Assuming she currently has no savings, use the RATE function to calculate what rate of return she would need each period (defined in cell c7) to reach that goal. #10 Format cells with percentages using the Percentages format, and cells with dollar amounts using the Currency format. In both cases, display two decimals. with dollar amounts or percentages as Currency or Percentage, respectively. #2 Use the NOMINAL function to convert the effective annual return in cell C5 to an APR. Be sure your formula links to cell C7 since the compounding frequency must match the savings frequency. #3 Use the NOMINAL function to convert the effective annual return in cell C6 to an APR. Be sure your formula links to cell C 7 since the compounding frequency must match the savings frequency. #4 Use the FV function to calculate how much Dalia will have in savings when she gets to retirement. #5 Use the PMT function to calculate how much Dalia can spend each period while in retirement (use the same number of periods in a year as specified in cell c7). #6 Calculate the amount she will have at retirement (cell c11) if she already has $35,000 in her retirement account. Hint: this is easiest to do by using the optional [pv] argument in the FV function. #7 Use the PMT function to calculate the amount she can spend each period in retirement given the amount you calculate cell 1616 . #8 Dalia would like to have $2,000,000 in her account at retirement. Assuming she currently has no savings, use the RATE function to calculate what rate of return she would need each period (defined in cell c7) to reach that goal. #10 Format cells with percentages using the Percentages format, and cells with dollar amounts using the Currency format. In both cases, display two decimals