FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
If you wanted to do an Excel What-If Analysis of a system with eight different inputs which tool would you use?
A
Scenario
B
Data Table
C
Goal Seeking
D
None of the above
Explanation: 

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).

There is 1 question to complete.