DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Scenario
|
|
|
Data Table
|
|
|
Goal Seeking
|
|
|
None of the above
|
Detailed explanation-1: -Answer: May be the answer is Data Table.
Detailed explanation-2: -Scenario Manager is one of the What-if Analysis tools in Excel. Scenario Manager is useful in a case where you have more than two variables in the sensitivity analysis. Scenario Manager creates scenarios for each set of the input values for the variables under consideration.
Detailed explanation-3: -Go to the Data option from the toolbar and select the Excel What-if Analysis option from the Forecast Ribbon, as shown below. A dialog box will appear on the screen with empty scenarios. To add a scenario, select add option as shown below. Then, a new dialog box will appear on the screen with cell addresses.
Detailed explanation-4: -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.
Detailed explanation-5: -Step 1-Click ‘What If Analysis’ from the Data tab and select Scenario Manager. Step 2-Click ‘Add’ from the Scenario Manager pop-up window. Step 3-Name this scenario “Original” and enter the cell references of all cells with constant values that you may consider changing in other scenarios (maximum 32 cells).