____ References Make It Easier to Create Formulas That Use

question 111

Multiple Choice

____ references make it easier to create formulas that use portions or all of an Excel table because the names or headers are usually simpler to identify than cell addresses.

• A)Indexed
• B)Structured
• C)Key
• D)Logical

---

Definitions:

Noncumulative Quantity Discounts

Discounts that apply to a single order rather than the total volume of orders over a certain period, encouraging large individual purchases.

Cumulative Quantity Discounts

A pricing strategy where the price per unit decreases as the total quantity purchased over time increases.

Seasonal Discounts

Price reductions offered during specific times of the year to stimulate sales during slow periods.

Inventory

The quantity of goods or materials on hand that a business holds for the purpose of resale or production.