Page 199 - Trackpad 402_Class-X_Final
P. 199
In the given example, we have created 4 scenarios of four friends’ marks. You can easily switch between these sets
using the Navigator tool present on the Standard toolbar or a drop-down list which can be shown beside the
changing cells. If you click on each scenario the corresponding marks of the weekly test, half yearly and final exams
changes and on that basis the total and percentage will be displayed. The set of four scenarios with the corresponding
set of cells are displayed below:
GOAL SEEK ANALYSIS
Goal Seek is another What-if Analysis tool of OpenOffice Calc. It is a tool that helps you do backward calculation of the
input to obtain the desired output.
Let us take as an example that Anurag wants to score 94% in his weekly tests, but his Maths is weak. He scored only
83% in his weekly tests in Maths. If he would like to cover these marks in the improvement exam, then what should
be his target?
Let us do this using Goal seek. For this, follow the given steps:
Step 1: Create a sheet with the given values in all 5 subject’s marks of weekly test. Calculate the percentage in the
cell B9 and select the cell B9.
Step 2: Click on Tools menu and select Goal Seek’ option. The Goal Seek dialog box opens containing following three
options:
Electronic Spreadsheet (Advanced) 199

