State the purpose for each of the following six built-in spreadsheet functions.

(a) PV(i%, n, A, F)
(b) FV(i%, n, A, P)
(c) RATE(n, A, P, F)
(d ) IRR(first_cell:last_cell)
(e) PMT(i%, n, P, F)
( f ) NPER(i%, A, P, F)


(a) PV(i%,n,A,F) finds the present value P
(b) FV(i%,n,A,P) finds the future value F
(c) RATE(n,A,P,F) finds the compound interest rate i
(d) IRR(first_cell:last_cell) finds the compound interest rate i
(e) PMT(i%,n,P,F) finds the equal periodic payment A
(f) NPER(i%,A,P,F) finds the number of periods n

Trades & Technology

You might also like to view...

Technician A says that the number of threads per inch on a metric bolt, is called pitch. Technician B says that metric bolt threads are designated by the distance between threads measured in millimeters. Which technician is correct?

A) Technician A only B) Technician B only C) Both technicians D) Neither technician

Trades & Technology

A turret type tool post normally:

A) Holds 4 different tools B) Use standard toolholders C) Holds 6 different tools D) Use quick-change toolholders

Trades & Technology

How many bits are required to represent 51310 as a signed binary numbers in 2's complement form?

A) 11 B) 10 C) 9 D) 8

Trades & Technology

Permanent electrical safety devices can improve the effectiveness of lockout/tagout programs