Which is used to perform what if analysis? A. Solver B. Goal seek C. Scenario Manager D. All of above

Solver
Goal seek
Scenario Manager
All of above

The correct answer is D. All of the above.

Solver, Goal Seek, and Scenario Manager are all tools that can be used to perform what-if analysis in Excel. What-if analysis is a process of exploring the possible outcomes of a decision by changing one or more variables.

Solver is a tool that can be used to find the best solution to a problem by changing the values of one or more variables. Goal Seek is a tool that can be used to find the value of a variable that will make a formula return a certain value. Scenario Manager is a tool that can be used to create and compare different scenarios.

Here is a brief explanation of each tool:

  • Solver: Solver is a tool that can be used to find the best solution to a problem by changing the values of one or more variables. Solver can be used to solve a variety of problems, such as finding the optimal price for a product, or finding the best mix of products to produce.
  • Goal Seek: Goal Seek is a tool that can be used to find the value of a variable that will make a formula return a certain value. For example, you could use Goal Seek to find the price of a product that will result in a profit of $100.
  • Scenario Manager: Scenario Manager is a tool that can be used to create and compare different scenarios. A scenario is a set of values for the variables in a model. For example, you could create a scenario for a product launch with a high sales forecast, and another scenario for a product launch with a low sales forecast.

I hope this helps!

Exit mobile version