2. Go to the Q1 worksheet. 000 10 11 a) Using the annual interest rates (A10:A26) and years (B9:D9) provided, create a two-variable data table that will calculate the corresponding monthly payment amount (B5) for each annual interest rate and number of years in the table. (8 points) 12 13 14 15 16 17 18 19 20 21 b) Custom format cell A9 to display Annual Interest Rate instead of the value in it (there will be a sign before the text if you work on it correctly). (4 points) 8 D E $ 250,000, 4.50% 15 1 New Home Price 2 Annual Interest Rate 3 Term (years) 4 5 Monthly Payment 6 ($1,912.48) 8 PMT Values Table Term (years) 10 15 20 9 14 15 16 17 18 19 1.00% 1.25% 1.50% 1.75% 2.00% 2.25% 2.50% 2.75% 3.00% 3.25% 3.50% 3.75% 4.00% 4.25% 4.50% 4.75% 5.00% 20 21 22 23 24 25 26 28 29