Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

______ is a statistical function a. RATE b. DDB c. FORECAST d. RAND The function

ID: 3926459 • Letter: #

Question

______ 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

Explanation / Answer

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