Page 156 - IT_V1.0_Class10
P. 156

Step 8:  Click on Yes button.
              Step 9:  Estimated marks of Computer subject is 75 to get 80% aggregate.










                       8
                                                                                                             9


                     Do you know?


                    We can click the Shrink icon to reduce the dialog box to the size of the input field. It is then easier to
                    mark the required reference in the sheet. Clicking it restores the dialog box to its original size. The dialog
                    box is automatically minimised when you click on the sheet with the mouse. As 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.


                                                                                                  21 st
                                                 Lab Assignment ‘n Activity                    Century   #Technology Literacy
                                                                                                 Skills


                    Complete the following activity and tick the circle.
                    Vishal is the manager of a store that sells electronic gadgets. His goal is to achieve a monthly
                    revenue of ₹50,000. Currently, he sells three types of gadgets: A, B, and C. He has the following
                    information:

                    (a) Gadget A sells for ₹100 each.          (b) Gadget B sells for ₹150 each.
                    (c) Gadget C sells for ₹200 each.

                      This month, he expects to sell 200 units of Gadget A and 150 units of Gadget B. He wants to
                    determine how many units of Gadget C he needs to sell to reach his revenue goal of ₹50,000.
                      Using Goal Seek, how can he find the number of units of Gadget C needed to achieve your
                    target revenue?




                 SOLVER

              Solver is an advanced version of Goal Seek in LibreOffice Calc. While Goal Seek allows you to manipulate one
              input cell to achieve a fixed outcome or target, Solver can handle equations with multiple unknown variables.
              Solver enables you to manipulate a set of cells to achieve a desired output, estimating the minimum or
              maximum values for these cells.

              Solver is specifically designed to optimise results according to a set of limiting rules defined by the user. Each
              rule specifies whether an argument in the formula should be greater than, less than, or equal to a given value.
              If an argument should not be changed, you can set the rule so that the argument in the cell is equal to its
              current value.

              Lets continue with our previous example of Manisha who has scored less marks and she wanted to
              score more.



                154     Information Technology Play (Ver 1.0)-X
   151   152   153   154   155   156   157   158   159   160   161