In what cell is the Rate for PMT function where = PMT (C8, C9, C10, C…

The correct answer is Option (1) → C8

The syntax of the function is =PMT(rate, nper, pv, [fv], [type]). The arguments are read in this fixed order, so the first cell named holds the rate.

In =PMT(C8, C9, C10, C11, C12): rate = C8, nper = C9, pv = C10, fv = C11, type = C12.

Option (2) C10 — Incorrect. The third argument is pv, the present value.

Option (3) C9 — Incorrect. The second argument is nper, the number of periods.

Option (4) C12 — Incorrect. The last argument is type, the timing of payments.