Goal Seek adjusts one input until a formula hits a target—quick sensitivity without full Data Tables.
Goal Seek
Data → What-If Analysis → Goal Seek: set cell (formula), to value, by changing cell (input).
Scenarios
Scenario Manager stores input sets (best/base/worst case) for comparison.
Data Table
One- or two-variable tables show formula results across input grids.
Important interview questions and answers
- Q: Goal Seek limit?
A: One variable at a time—complex models need Scenario Manager or Python. - Q: Scenario Manager?
A: Saves named assumption sets.
Self-check
- What does Goal Seek change?
- When use Scenario Manager?
Tip: Document Goal Seek inputs in a comment—results are not formula-transparent.
Interview prep
- Goal Seek?
Adjust one input until formula hits target.