Type the future value of $1 at 6 % compounded monthly for four years, adjusting both arguments inline.

Answer

=FV(0.06/12,4*12,0,-1)

Returns 1.2705. The rate is divided by 12 and the years multiplied by 12 inside the same call, so neither adjustment can be forgotten.

Bigel, Introduction to Financial Analysis (CC BY 4.0) §10.2 q4–5, §10.4