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

Unit-2 Electronic Spreadsheet (Advanced)





                 ADVANCED FEATURES OF SPREADSHEET                                                      2












                   Data is one of the most important sources for analysing or getting proper information. Generally,
                   while working in o ce we get data under different fields but this data may be related to each
                   other.
                   Such data is kept in numerous worksheets but it is useful when the related data can be compared
                   edited or manipulated. It becomes necessary to merge different data into single sheet. Spreadsheet
                   package is of great help in sharing  merging  referencing  hyperlinking  consolidating  etc.


                      CONSOLIDATING DATA

                    ata consolidation refers to collecting and integrating data from multiple worksheets or workbooks
                   into a single/master worksheet.
                    uring this process  the   ata  onsolidation  function takes data from a series of worksheets or
                   workbooks and summarise it into a single worksheet.

                   To Combine Cell Contents
                     Open the worksheet of  istrict     istrict   and  istrict   which contains the cell ranges to be
                     consolidated.

                   Worksheet of District A


































         158       Touchpad Information Technology-X
   155   156   157   158   159   160   161   162   163   164   165