Question

Which tool helps better for what if analysis in MS Excel ?
1. Track Change
2. Formula Auditing
3. Goal Seek
4. Pivot Table

Answer 1

Correct Answer - Option 3 : Goal Seek

Concept:

What-If Analysis is the process of changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet.

Three kinds of What-If Analysis tools come with Excel

• Scenarios : A Scenario can have multiple variables, but it can only accommodate up to 32 values.Scenarios and Data tables take sets of input values and determine possible results.
• Goal Seek: Goal Seek works differently from Scenarios and Data Tables in that it takes a result and determines possible input values that produce that result.
• Data Tables: A Data Table works with only one or two variables, but it can accept many different values for those variables.