The XYZ Bank is considering increasing the interest rates it provides to checking account holders. Revise the table below so that earnings with interest rates of 4%, 5%, and 6% can be compared, as shown below: 1 2 3 4 5 6 7 A D E Interest Rate Amount Interest Earned at 4% Interest Earned at 5% Interest Earned at 6% 4% $ 5,375.00 $ 215.00 $ 268.75 $ 322.50 5% $ 486.22 6% $ 8,734.23 $10,750.52 $ 312.11 $ 79.45 a) Drag the formula used in cell C2 to cells D2 and E2. Modify the formulas in cells D2 and E2 so that each refers to the appropriate interest rate. b) Using absolute referencing to refer to the appropriate interest rate, drag your formulas in cells D2 and E2 through the remaining cells in each column to compute the amount of interest earned on the other accounts at 5% and 6%