When a Year Value Lower Than 30 Is Entered in a Cell,for

question 83

True/False

When a year value lower than 30 is entered in a cell,for example 2/12/18,Excel assumes that the date is in the 21ˢᵗ century.

---

Definitions:

Rate of Return

The profit or deficit accrued from an investment during a certain timeframe, depicted as a percentage of the investment's original value.

Nominal Rate

The stated interest rate of a loan or financial product, not adjusted for inflation or other factors that affect the real rate of return.

Effective Rate

The actual interest rate earned or paid on an investment, loan, or other financial product, taking into account the effect of compounding.

Compound Interest

This refers to the calculation of interest on the original amount of money deposited or borrowed as well as on the interest that has already accumulated over previous periods.