1 Year Certificate of Deposit Amount Deposited: $7,500.00 Rate of Return: a.) Value after 1 year: b.) Value after 1 year using IF: c.) Your bank is offering a 1 year Certificate of Deposit (CD) at 1.5% for investments under $5,000. Ifyou invest $5,000 or more they offer 2.2%. l 3.) Enter an IF function which outputs the correct rate of return based on the given deposit. Format as a percentageto 1 decimal place. b.) Use your rate of return to compute the value of the CD after 1 year. Format as currency with 2 decimal places. c.) Vour IF function from part a has two possibilities: 1.5% or 2.2%. Assume instead of the rate ofreturn you want the output to actually be the value of the CD after 1 year. Enter a new IF function which does this. Format as currency with 2 decimal places. In cell C8, use the IF function to determine the rate of return based on the deposit in cell C7. Format cell C8 as Percentage with 1 decimal place. In cell C9, calculate the value of the CD after 1 year if the rate of return is in cell C8. Format as Currency with 2 decimal places. In cell C15, use the IF function to calculate the value of the CD after 1 year based on the deposit in cell C7. Format as Currency with 2 decimal places. Note: Do not use the answers from steps 2 and 3 in your calculations