In this article, you will get Comprehensive notes using goal seek and solver class 10 in an electronic spreadsheet (Advanced) which is the learning outcome is analyzing data using scenarios and goal seek. Let us start!
Topics Covered
Comprehensive notes using goal seek and solver class 10
A spreadsheet software supports many features to analyze data and make a trustworthy decision according to results. If you missed the previous articles read from the below-given links:
Now let’s start this article using goal seek and solver class 10 with the meaning of goal seek.
What is Goal Seek?
Goal seek is an advanced spreadsheet feature that allows to provides the values for the target based input. Just decide the target value and you can select which cell should be changed in goal seek dialog box.
In the next section of the article using goal seek and solver class 10, you will learn how to use goal seek in MS excel.
Steps to apply goal seek in MS Excel
To apply goal seek in MS excel worksheet, enter the data, and perform the calculations as you want. I have prepared the following data to perform goal seek in MS Excel.
 |
| GoalSeek Data |
In the above screenshot, Rate and Quantity are given and the amount is computed accordingly. Now I want to achieve the target amount of 500, so what should be rate can be or how many quantities required for the same, goal seek helps to do the same.
-
- Select the cell where the formula is written. For my example, I have placed the cursor in B4.
- Click on Data → What-if Analysis → Goal Seek option from the forecast group.
Data – What if Analysis – GoalSeek - A GoalSeek dialog box will appear as displayed in the following screenshot:
GoalSeek in MS Excel 2019 - Type the desired value i.e. 500 in To Value box and select the cell address for by changing cell option as displayed in the following screenshot.
GoalSeek input - Click on OK button the values will be displayed in your worksheet as displayed in the following screenshot.
- Click on OK button to accept the result, click cancel to return with original data.
In the next section of using goal seek and solver class 10 you will learn how to use goal seek in LibreOffice Calc.
Goal Seek in OO Calc
-
- Place the cursor in B4 cell and click on Tools → GoalSeek option.
- A Goal Seek dialog box appears as displayed in the following screenshot.
- Type the desired value for target value and select the variable cell to display the changed value. Observe this dialog box.
- Now click on OK button. A result will be displayed in a new dialog box. Observe the following screenshot.
- Click on Yes button to accept the value. The result will be displayed as below given screen shot.
- Place the cursor in B4 cell and click on Tools → GoalSeek option.
The next section of using goal seek and solver class 10 will tell about solver. Let’s start!
Solver in OO Calc
GoalSeek allows displaying the target based results on a single value or condition. Whereas the solver is used to optimize the result based on conditions. Follow the given steps to use solver:
-
- Place the cursor in the cell where the formula is entered.
- Now Click on Tools → Solver.
- Now, a solver dialog box will appear as displayed in the following screenshot.
- Select the optimized result to option, select the by changing cells and provide the value in limiting conditions. Observe the following screenshot of what I have done!
- Click on the Keep result button to accept the changes otherwise click on restore previous.
I hope you enjoyed the reading of this article using goal seek and solver class 10. Thank you for reading the complete article. Share this article with your friends and feel free to ask your doubts in a comment section. Do like our social media pages for discussion and more updates.
Follow the below given link to access all the contents: