explain various tools available to do what-if analysis with their usage
Answers
Answered by
3
Explanation:
Three kinds of What-If Analysis tools come with Excel: Scenarios, Goal Seek, and Data Tables. Scenarios and Data tables take sets of input values and determine possible results. A Data Table works with only one or two variables, but it can accept many different values for those variables.
Answered by
2
Explanation:
Three kinds of What-If Analysis tools come with Excel: Scenarios, Goal Seek, and Data Tables. Scenarios and Data tables take sets of input values and determine possible results. ... You can also create forecasts by using the fill handle and various commands that are built into Excel.
Similar questions