explain any two what if analysis toolof excel
Answers
Answered by
6
Answer:
A Scenario is a set of values that Excel saves and can substitute automatically on your worksheet. You can create and save different groups of values as scenarios and then switch between these scenarios to view the different results.
Explanation:
Hope this could help you mark me as brainist and thanks my answers..!
Answered by
6
Answer:
Hope this helps you.
Explanation:
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, Goal Seek, and Data Tables. ... The Solver add-in is similar to Goal Seek, but it can accommodate more variables.
Similar questions