Formula Anatomy & Mixed Cell Locking ($A$1)
Write readable multi-cell formulas using relative vs absolute ($A$1) and mixed ($A2 / B$1) references for rate tables.
Key takeaways while you watch
- Lock the tax or FX assumption cell with $B$1 before dragging down rows.
- Use F4 to cycle through $B$1 -> B$1 -> $B1 -> B1 quickly.
- Keep rates and percentages in dedicated input cells instead of hardcoding numbers inside formulas.
Drill: Multiply Price by Locked Tax Cell
Write a formula for cell C2 that multiplies B2 (Net Price) by E1 (Tax Rate) so E1 stays locked when filled down column C.
| Item | Net Price (B) | Tax Amount (C) | Tax Rate (E1) | |
|---|---|---|---|---|
| Monitor Arm | 120 | =? | 0.08 | |
| Desk Lamp | 45 | =? |
Module 01 Knowledge Check
Answer all 3 questions and check your score to unlock credit toward completion.