Goal Seek :-
Goal seek is a what if analysis tool that helps you to find the input value that results in a target values that you want. We can say that if you know the result that you want from a formula. But not the input value the formula needs to get that result, you can use the Goal Seeks features.
Using Goal Seek:- Goal seek tools need three parameters:-
1. The formula cell:- This is the cell contains the formula we want to resolves.
2. Target Value: - The required value that we want our formula to resolve to.
3. The variable cell:- The cell that contains the unknown data that we want to
find a value.
Goal Seek Step -
1. Fill the cell with data above figure and select the cell containing the formula (Average).
2. Click on Tools Menu
3. Select Goal Seek Option, A goal seek dialog box will appear.
4. In the goal seek dialog box fill the parameters. The formula cell is already filled in. Type in the target value and click the variable cell to auto fill the cell reference value in dialog.
5. Goal seek now calculates and displays the result in another pop up dialog. Choose yes to insert the result into variable.
6. Now the student knows that he must achieve Marks 55 or greater in the Computer exam in order to pass the course.
0 Comments