Page 191 - Trackpad 402_Class-X_Final
P. 191

UNIT                                       Electronic Spreadsheet

               2                                                       (Advanced)









                   Topics Covered                                                                          95%

                     Data Consolidation                          Creating Subtotals
                     Using WHAT-IF Scenarios                     Goal Seek Analysis
                     Using Solver                                Linking Data and Worksheets
                     Cell Reference                              Working with Hyperlinks in a Sheet
                     Sharing Worksheet Data                      Record Changes in a spreadsheet
                     Adding Comments to Changes                  Merging Worksheets
                     Comparing Documents                         What are Macros?




            Data analysis is an important part of many professional places. It is required to study the trends of products required
            in the local and global market. It is an important part of many organization for planning and taking important decisions
            for the progress of the company. The important data analysis tools available in OpenOffice spreadsheet are Data
            Consolidation, What-if Analysis, Goal Seek and many more. In this unit we will study about these important data
            analysis tools.



                    DATA CONSOLIDATION

            Data consolidation  means to  collect  data from different sources into a common  place by using  different built  in
            functions like sum(), max(), min(), average(), etc. Data consolidation is used for data collection so that data analysis
            can easily be done. The data of similar type from different sheets in the same workbook is picked up, consolidated and
            saved for further data analysis.
            Let us take an example of adding the marks of weekly test, half yearly and finals stored in three different sheets in the
            same workbook so that the consolidated marksheet of a student can be generated.

            The steps to consolidate data are as follows:
            Step 1:  Create sheet1-weekly test, sheet2-half yearly and sheet3-finals in Final Result.ods.
















            Step 2:  Select the range B3:B8 in the ‘weekly test' sheet.



                                                                                 Electronic Spreadsheet (Advanced)  191
   186   187   188   189   190   191   192   193   194   195   196