If a Worksheet Arranges Lookup Values in Rows Rather Than

question 457

Multiple Choice

If a worksheet arranges lookup values in rows rather than columns, which function is best for retrieving data from the lookup table?

• A) VLOOKUP
• B) HLOOKUP
• C) INDEX
• D) MATCH

---

Definitions:

Sales Commissions

Remuneration given to sales staff based on the total amount of sales they generate, aimed at motivating higher sales output.

Monthly Sales

The total revenue generated from the sale of goods or services within a specific month.

Net Operating Income

is the total profit of a business after deducting operating expenses but before subtracting taxes and interest.

Contribution Margin Ratio

A metric that reveals the percentage of sales revenue that exceeds variable costs and contributes to covering fixed costs and generating profit.