Comprehensive notes What if scenarios what if tools Class 10

The “What If” scenario feature allows us to create different target-based “What If”  analysis. Suppose we are playing a clicket tournament where we need to analyze our team performance on the net run rate we can use “What If” scenarios. Moreover, it can help in every match to achieve the target in different conditions.

 

These different conditions means

You can create scenarios with different names and targets. These scenarios you can view any time from the scenarios manager. 

 

In the next section of what if scenarios what if tools you will learn how to use it in MS Excel.

MS Excel provides What-If-Analysis command in the Data tab to use “What IF” scenarios. Prepare your data in advance and open the worksheet then follow the given steps. I have used the following data for this purpose.

 

Step 1: Select data and click on  Data → What – if – Analysis → Scenario Manager. Observe the following screenshot:

 

Step 2: Click on the scenario manager.  The Scenario Manager dialog box appears as displayed in the following screenshot.

 

This dialog box has the following options:

1. 1. Scenario Details Preview: It shows the details of the scenarios.
   2. Add: You can add a new scenario by clicking this option.
   3. Delete: You can delete an existing scenario that is unwanted.
   4. Edit: You can edit an existing scenario.
   5. Merge: It is useful, If more than one scenario needs to be added 
   6. Summary: It shows a summary of the scenario.
   7. Changing Cells: Select the cells in which values are going to be changed.
   8. Comment: If any additional text is required then you can insert it.
   9. Show: Display the information of the selected scenario.
   10. Close: To close the scenario manager.

Step 3: Click on the Add button. Add scenario dialog box will appear as displayed in the below-given screen shot.

Type the scenario name as I have scenario1, you can change cells by selecting changing cells options. Type your comments if you want to type in the comment box. Click on the OK button. Scenario values dialog box appears as displayed in the following dialog box. 

 

Scenario Values Dialog box

Step 4: Now enter the target values in the respective cells. My target which I want to use for this scenario is 120 runs in 10 overs and want to concede 90 runs in 10 overs to see the net run rate variations. So I have changed these values respectively. 

Step 5: Click on the Add button. Repeat the same steps for more scenarios. 

 

In the next section of what if scenarios what if tools you will learn how to check the result of scenario.

To check the scenario result follow these steps:

Step 1: Open the scenario manager. 

Step 2: Select the scenario which results you want to check. Click on the scenario name.

Step 3: Click on the show button.

 

The result will be displayed in the excel worksheet. 

 

Consider similar data as used in MS Excel example. Follow the below-given steps to use the “What-if” scenario in OO Calc.

Step 1: Type the required values in the excel sheets and click on Tools → Scenarios option. 

 

Step 2: A create scenario dialog box appears as displayed in the following screenshot.  

 

• Name of Scenario: Type the name of the scenario.
• Comment: Type the remarks or comments related to the scenario.
• Settings: It allows to change the display border colour, copy the contents, copy the entire sheet as well as the prevention changes.
• OK: When set up is complete click the OK button.

Step 3: Apply the settings you need in your current scenario and click on the OK button. I have applied a blue border to a scenario and changed the value runs scored 80 and runs conceded 75 and the result is 0.5. Observe the following screenshot. 

 

 

You can use a down arrow to view more scenario results.

 

In the next section of what if scenarios what if tools will multiple operations. 

The scenario allows us to perform a task on a single set of values at a time. But what if you want to see multiple results at the same time? So OO calc provides a strong feature named Multiple operations to do the same thing. You can set input row values according to the row or columns. 

 

Type the target values in the desired cells in a single column. I have typed the assumed target in a column displayed in the screenshot.

 

This section talks about the steps to be performed for multiple operations for what if scenarios what if tools. 

 

Select the data along with the adjacent column and follow the below-given steps:

Step 1: Click on Data → Multiple Operations. Multiple operations dialog box appears have look in the following screenshot.

Multiple Operations dialog box in OO Calc

This dialog box consists of three options:

• Formulas: Select the cell where formula is entered.
• Row input cell: Select the cell for the input values that are entered in rows.
• Column input Cell: Select the cell for the input values that are entered in columns.

Step 2: As per my data, the values are stored in a column and the formula is entered in B6. For column input cell  I have selected the cell B2. Observe the following screenshot.

 

Step 3: Click on the OK button. You will get the desired result. Observe the following screenshot.

 

Similarly, you can type the values in a row and check multiple operations result accordingly.

 

Watch the complete video tutorial for the same. If you have any queries or doubts, please comment in the comment section.