FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Excel includes powerful tools to perform complex mathematical calculations, including what-if analysis. This feature can help you experiment and answer questions with your data, even when the data is incomplete. In this lesson, you will learn how to use a what-if analysis tool called Goal Seek.

Detailed explanation-2: -How What if analysis helps experiment and answer questions with the data?. What-If Changes to cell values are analysed to determine how they may impact the results of formulas on the worksheet. Scenarios, Goal Seek, and Data Tables are the three different What-If Analysis tools that are included with Excel.

Detailed explanation-3: -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.

Detailed explanation-4: -What-if analysis, which is also called sensitivity analysis, is a tool for determining effects on outcomes in a mathematical model by changing the inputs to the model in multiple scenarios.

Detailed explanation-5: -In the above scenarios, you want to know the degree to which each change affects the overall outcome. For this reason, a what if analysis is also known as a sensitivity analysis. Most what if analyses are really mathematical calculations, and that is Excel’s specialty.