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

onsolidate  window appears on the screen.

        Step 3:   lick on the  Source  ata  ange  area box.   blinking cursor will appear in the box.
        Step 4:  Select a source cell range from the worksheet to consolidate with other areas.




                             3









                                                                                           4





        Step 5:   lick on   dd  button to insert the selected range in the   onsolidation ranges  field.








                                                    Add Consolidation
                                                         Range


                                                                                           5

                             6



        Step 6:   Select additional ranges from different worksheets and then click the   dd  button again for each
                selection.
        Step 7:    lick on the   opy results to  area box.   blinking cursor appears in the box.

        Step 8:  Select a target cell range in which all the data are re uired to be consolidated.
















                                                                                           8
                             7


                                                                                 10

        Step 9:  Select  desired  function  from  the   Function   box.   he  function  specifies  how  the  values  of  the
                consolidation ranges are linked.  he  Sum  function is the default setting.


         160       Touchpad Information Technology-X
   157   158   159   160   161   162   163   164   165   166   167