CIS 105 - 3.15

The rate for Year 2 is very high. What is the correct formula?

• D4 = LEFT(PI()/ROW(D5),4)%

• D6 =RIGHT(PI()/ROW(D5),3)%

• D6 = RIGHT(PI()/ROW(D4),3)%

• D5 = LEFT(PI()/ROW(D5),3)%

The age of person for Year 24 and Year 25 is the same, correct the formula.

The rate for Year 10 is 061, what is the correct formula?

• D14 =RIGHT(PI()/ROW(D13),3)%

• 
  D15 = LEFT(PI(),ROW(D13),2)%

• D16 = RIGHT(PI()/ROW(D13),2)%

• D14 = LEFT(PI(),ROW(D12),2)

In outputs table, the number of annual payments should be 20, correct the formula.

The total amount invested in Outputs table seems low, what is the correct formula?