What Excel Function/feature Should Be Used to Calculate a Moving

question 59

Multiple Choice

What Excel function/feature should be used to calculate a moving average?

• A)Solver
• B)=AVERAGE
• C)=MAVE
• D)Goal seek

---

Definitions:

Market Interest Rates

The prevailing rate of interest available in the marketplace on investments and borrowing.

Exercise Price

The price at which the holder of an option can buy (for a call option) or sell (for a put option) the underlying asset.

Risk-Free Rate

The theoretical rate of return of an investment with zero risk of financial loss, often represented by the yield on government bonds.

Option

A contract that gives its owner the right to buy or sell some asset at a fixed price on or before a given date.