is a statistical function a RATE b DDB c FORECAST d RAND Th
______ is a statistical function
a. RATE
b. DDB
c. FORECAST
d. RAND
The function IRR:
a. approximates the internal rate of return for a series of cash flows
b. returns an error
c. computes the modified internal rate of return
d. computes the interest rate per period required to make a present investment
=INT(27.3) will return the value of:
a. 81
b. 27
c. 24
d. 9
The _____________ function predicts the next value in a series
a. ABS
b. FORECAST
c. GROWTH
d. MIRR
_________ represents the number of periods for annuity or amount to reach future value.
a. RATE
b. FV
c. PMT
d. NPER
Solution
The function RR is
Answer: Approximates the internal rate of return for a series of cash flows
=INT(27.3) will return the value of:
Answer:27
The ABS function predicts the next value in a series
Answer: ABS
FV represents the number of periods for annuity or amount to reach future value.
Answer: FV

