Page 176 - IT 402 v2.0 class 10
P. 176

Lab Assignment ‘n Activity                             Cr itical   T h ink ing



             Complete the following activities and tick on the circle.

                 onsider the worksheet as shown below.














                Ob ective is to get Maximum  rofit by optimising the  uantity using  Solver .
                 onstraints:   ere  are  a  couple  of  constraints  that  must  be  considered  while  trying  to
                maximise the profit.
                    uantity of  roduct     should be made at least     .

                    uantity of  roduct     should be made at least     .
                    uantity of  roduct     should be made at least     .
                    otal  uantity of  roducts should be made   5  .


           LINK DATA AND SPREADSHEETS

        Spreadsheet allows linking among data associated within cells from various worksheets to summarise data
        from several sources.

        Setting Up Multiple Worksheets
         very workbook contains at least one worksheet by default.  hile working with a large amount of data
        multiple worksheets can be created to organise the workbook and make it easier to find data.  orksheet
        can also be grouped to  uickly add information to multiple worksheets at the same time.  y default  every
        workbook contains a sheet named  Sheet   which is managed using tabs at the bottom of the spreadsheet
        as shown below:
























                                                        Sheet Tab



         174       Touchpad Information Technology-X
   171   172   173   174   175   176   177   178   179   180   181