Page 158 - IT_V1.0_Class10
P. 158

DIFFERENCE BETWEEN GOAL SEEK AND SOLVER


              Goal seek determines what values needs to be input in a specific cell to achieve the described result in a
              formula cell as it allows varying the value for one cell whereas Solver can solve equations that uses several
              variables, so it can be used to determine what values need to be entered in multiple input cells to achieve
              the described result.

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


                   Complete the following activities and tick the circle.
                     Consider the sheet as shown below.











                     Objective is to get Maximum Profit by optimising the Quantity using Solver.
                      Constraints: Here are  a couple of constraints that  must be considered while trying  to
                      maximise the profit.
                     (a)  Quantity of Product 'A' should be made at least '90'.
                     (b)  Quantity of Product 'B' should be made at least '30'.
                     (c)  Quantity of Product 'C' should be made at least '20'.
                     (d)  Total Quantity of Products should be made '350'.;



                  Recap Zone


                    Data consolidation refers to collecting and integrating data from multiple sheets or spreadsheets
                   into a single/master sheet.
                    Group and  Outline allows you to organise data  by grouping  rows or columns, enabling you to
                   collapse or expand them with a single click.
                    The  Subtotal command  is used  to  automatically  create  groups  and  apply  inbuilt functions  like
                   SUM, COUNT, AVERAGE, etc., to summarise data.
                    Scenario is a tool to test ‘what-if’ questions. By adding a Scenario, you can easily view new results for
                   the arguments of a formula. You can create several scenarios for any given range of cells.
                    What-If Analysis can be performed by changing the values in cells to see how those changes will
                   affect the outcome of formulas on the sheet.
                    Like scenarios, Multiple Operations is also a planning tool for ‘what-if’ questions. Unlike Scenario,
                   Multiple Operations  tool does not  present  the  alternative  versions in the  same cells or  with  a
                   drop-down list.
                    Goal Seek option reverses the usual order of a formula.
                    Solver enables you to manipulate a set of cells to achieve a desired output, estimating the minimum
                   or maximum values for these cells.






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