Page 173 - IT 402 v2.0 class 10
P. 173
Step 3: he cell address containing the formula is already entered in a Formula cell field.
Step 4: nter the desired result i.e. .
3
4
5
Step 5: lace the cursor in the ariable cell field. In the sheet click in the cell that contains the value to be
changed. In this example is the cell.
Step 6: lick on O button.
Step 7: lick on es button.
Step 8: stimated marks of omputer sub ect is 5 to get aggregate.
6
7
8
Sneak Peek
Using Goal Seek in Microsoft Excel:
1. Select the cell that contains a formula.
. lick on ata tab and then click hat-If nalysis command from ata ools command
group. Select oal Seek option from the drop-down menu.
. dialog box will appear with three fields:
Set cell: his is the cell that contains the desired result.
o value: his is the desired result.
y changing cell: his is the cell where oal Seek places its answer.
. Set appropriate values and then click on O button.
5. dialog box appears on the screen informing whether oal Seek was able to find a solu-
tion. lick on O button.
. he result will appear in the specified cell.
Advanced Features of Spreadsheet 171

