To Create a Filter Using the Filter and Sort Dialog

question 20

Multiple Choice

To create a filter using the Filter and Sort dialog box, use the Field list arrow to select the field to filter, use the Comparison list arrow to choose the filter operator, and then type a value in the ____ text box.

• A) Compare to
• B) Field
• C) Comparison
• D) Sort by

---

Definitions:

Discount Rate

The interest rate used to discount future cash flows to their present value, enabling comparison of the value of investments made at different times.

Net Present Value

A method used to evaluate investments by calculating the present value of expected future cash flows minus the initial investment cost.

Cash Inflows

Refers to the money received by a company during a particular period, including revenues from sales, investments, and financing activities.

Minimum Acceptable Rate

The lowest rate of return on an investment that a manager or investor is willing to accept.