You're a finance analyst computing net-margin percentage for 10 products. Columns A–C contain ProductID, Revenue, and Cost.
Net margin % = (Revenue − Cost) / Revenue × 100.
Your task:
- In column D (NetMarginPct), write the formula using LET to bind
revenueAmount and costAmount to readable names — then compute the margin in terms of those names.
- Drag-fill from D2 → D11.
Graded cells: D2 (P-001 → 30), D7 (P-006 → 75), D10 (P-009 → 20).
Open this problem on a desktop to attempt it.