Page 155 - IT_V1.0_Class10
P. 155
GOAL SEEK
Goal Seek is used when our output or target value is fixed and we have to change any one of the input cell
values. Goal Seek option reverses the usual order of a formula. While creating a formula or function in a
spreadsheet, we use various parts together to calculate a result. Goal Seek works in the reverse way. It starts
with the desired result and it calculates the input value accordingly.
For example, Manisha has scored 67.5% aggregate, but she wanted at least 80% to qualify for yearly
scholarship. She skipped her Computer exam, now she has a chance to use her Computer subject’s score to
raise the aggregate. Here, Goal Seek can be used to estimate at least how much marks are to be scored in
Computer subject for availing that scholarship.
Follow the given steps to do so:
Step 1: Select the cell containing the formula (B8) to calculate percentage.
Step 2: Click on Tools menu.
Step 3: Select Goal Seek option.
The Goal Seek dialog box appears on the screen. Various components of the Goal Seek window are
as follows:
Formula Cell: it is used enter the reference of the cell that contains the formula.
Target Value: it specifies the value you want to achieve as a new result.
Variable Cell: it specifies the reference for the cell that contains the value you want to adjust to
reach the target.
The cell address ($B$8) containing the formula is already entered in a Formula cell field.
Step 4: Enter your desired result in Target Value field. Here it is 80.
Step 5: Click in the Variable cell field.
Step 6: Select the cell that contains the value to be adjusted. Here it is B7 as the marks in Computer to be
adjusted is selected.
Step 7: Click on OK button.
2
3
4
5
3
7
1
The LibreOffice Calc dialog box will appear.
Yes: to insert the result into the variable cell.
No: to not insert the result into the variable cell
Analyse Data using Scenarios and Goal Seek 153

