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
   150   151   152   153   154   155   156   157   158   159   160