A D 10% 1 Interest rate 2 Nper 3 PV 15 $ 1,700 I=SB$3*(1+$B$1)^$B$2 4 FV Study the screenshot above. What will happen to the formula contained in B4 should we cut the contents of Cell B1 (10%) and paste it to cell D2 on the worksheet? Select one: a. The cell will return a #REF! error. O b. The formula will update so that the middle part ($B$1) will be $D$2. c. There will be no change to the formula or value of the cell. d. The formula will no longer calculate the correct values. A B 1 P 10,000 9% 2 i 3 m 4 4 n 20 Refer to the above screenshot. P(1+i/m)mn can be entered as: Select one: a. =B1*(1+B2/B3)^(B3*B4) b. =B1x(1+B2/B3)(B3xB4) O O C. =B1(1+B2/B3)^B3*B4 d. =B1*EXP(1+B2/B3)(B3/B4) Study the screenshot below. Value at beginning Interest Value at end (compound) of year Year of year 1 21 3 4 In order to apply borders that look like those in the worksheet above, which option would you have to select from the Borders menu? Select one: a. Outside Borders b. Right border. c. Inside borders. d. All borders