Page 172 - IT 402 v2.0 class 10
P. 172
GOAL SEEK
oal Seek feature is an important part of hat-if nalysis feature of spreadsheet. oal Seek is basically used
when our output or target value is fixed and we have to make a change in any one of the input cell values.
oal Seek option reverses the usual order of a formula. hile creating a formula or function in spreadsheet
we use various parts together to calculate a result. oal Seek works in the reverse way. It starts with the
desired result and it calculates the input value accordingly. et s discuss about the various components of the
oal Seek window:
Formula Cell
In the formula cell we can enter the reference of the cell which contains the formula. It contains the current cell
reference. e can click another cell in the sheet to apply its reference to the text box.
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 ad ust in order to reach the target.
Shrink/Maximize
e can click the Shrink icon to reduce the dialog box to the si e of the input field. It is then easier to mark
the re uired reference in the sheet. he icon is then automatically converted to the Maximi e icon. licking
it restores the dialog box to its original si e. he dialog box is automatically minimised when you click on the
sheet with the mouse. s soon as you release the mouse button the dialog box is restored and the reference
range is highlighted in the document by a blue frame using mouse.
et s take an example where a student is currently scoring .5 aggregate and needs at least to ualify
for yearly scholarship. Fortunately he has a chance to use his omputer sub ect s score to raise the aggregate.
ere oal Seek can be used to estimate at least how much marks are to be scored in omputer sub ect for
availing that scholarship.
Step 1: Click on ‘Tools’ menu.
Step 2: Select oal Seek option. oal Seek dialog box appears on the screen.
1
2
Place the
cursor in the
formula cell
(i.e. 'B8').
170 Touchpad Information Technology-X

