One Way to Ensure That Correct Data Is Entered into a Cell

question 65

Multiple Choice

One way to ensure that correct data is entered into a cell or range is to use the Excel data ____ feature.

• A)validation
• B)concatenation
• C)security
• D)index

---

Definitions:

Payment Stream

A series of periodic payments that may be constant or variable, over time, often associated with loans or investments.

Discount Rate

In finance, the interest rate used to determine the present value of future cash flows, or in central banking, the rate charged to commercial banks for loans from the central bank.

Present Value

The present value is the current worth of a future sum of money or stream of cash flows given a specified rate of return.

Cash Flows

The total amount of money being transferred into and out of a business, project, or financial product, often analyzed to assess the entity's liquidity, solvency, and financial viability.