(Excel) Using EXCEL to do some calculating, suppose today yo…

(Excel) Using EXCEL to do some calculating, suppose today you have $1,000 in your savings account. If the yearly interest rate is r, then your savings balance in n years will be 1000(1+r)n (Hint: the formula written in Excel would be “=1000*(1+r)^n” ). Now we want to see how the savings balance would differ if the interest rate r and the number of years n vary. Consider the following example in Excel.     You must key a formula in cell C3, and then copy and paste it by dragging the lower right corner to all the other rows and columns of the table. Which of these is the appropriate formula for cell C3 with the correct use of relative and/or absolute cell references that would allow you to copy-paste the formula to the other cells such that the addresses for rows and columns gets updated automatically?