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:

ABC Analysis

A method for classifying inventory or items into three categories (A, B, and C) based on their importance, usually determined by value or usage rate.

Inventory Savings

Reductions in costs achieved through efficient management of stock, including ordering, storing, and using goods or materials.

Economic Order Quantity

A calculation that determines the optimal order quantity that minimizes total inventory costs, including holding, ordering, and shortage costs.

Safety Stock

An extra quantity of inventory kept on hand to prevent stockouts caused by unpredictable demand or supply delays.