USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
What-if Analysis
|
|
Whoa-What Analysis
|
|
Who-When Analysis
|
|
What-then Analysis
|
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. Scenarios and Data tables take sets of input values and determine possible results.
Detailed explanation-4: -Data Analysis Toolpak Click the File tab, click Options, and then click the Add-Ins category. Select Analysis ToolPak and click on the Go button. Check Analysis ToolPak and click on OK.
Detailed explanation-5: -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.