A spreadsheet lists 10 products with cost, price, and units sold. Sorted ascending by cost, which is the MOST EFFICIENT way to find the product with the highest margin per unit?
ACompute margin column then resort ascending by margin
BSort descending by price then inspect first row
CCompute margin column then resort descending by margin
DSubtract cost from price visually for top 3 rows
ESort ascending by units sold then inspect last row
Answer & Solution
Correct answer: C. Compute margin column then resort descending by margin
1. Identify what is being asked: this is a **Table Analysis** question.
2. Apply the standard approach for this question type to evaluate each option.
3. The correct answer is **C. Compute margin column then resort descending by margin** — it satisfies the conditions of the stem.
_Source: GMAT Focus DI Question Format Guide (examhunter.net)_
Related questions
Table shows 4 products. Highest margin = 22%. If revenue 1000, max profit:Table: column means: 10, 20, 30. Overall mean if columns are equal-sized:Table: ranks 1–5. Median rank is:Table: 30%, 40%, 30% split. If total = 200, middle bucket has:Table shows sales by region. Which region had highest growth?