AutoSave OFF x gtqleU_10_4_CD Q v Search Sheet Home Insert Draw Page Layout Formulas Data Review View N1 fx A B C D E G H L M N Q Your bank is offering a 1 year Certificate of Deposit (CD) at 4.5% for investments under 1 Year Certificate of Deposit $5,000. If you invest $5,000 or more they offer 5.2%. Amount Deposited: $ 7,500.00 Rate of Return: a.) Enter an IF function which outputs the correct rate of return based on the given deposit. Value after 1 year: Format as a percentage to 1 decimal place. b.) Use your rate of return to compute the value of the CD after 1 year. Value after 1 year using IF: c.) Your IF function from part a has two possibilities: 4.5% or 5.2%. Assume instead of the rate of return you want the output to actually be the value of the CD after 1 year. Enter a new IF function which does this. 35