Page 193 - Trackpad 402_Class-X_Final
P. 193

Step 7:     Click on ‘Source data range’ drop-down arrow. The data ranges created earlier will be displayed as shown below:




















            Step 8:     Click on data range names and click on Add. The data ranges will get added up in the Consolidation ranges
                     box. Repeat the step this all the data ranges needed for data consolidation are added in the Consolidation
                     ranges box.

            Step 9:   After all the three ranges are added the Consolidate dialog box will appear as shown below:



















            Step 10:   The list of the functions is available in the Function drop-down menu. Select the required function. In our
                     example taken above we need sum function which is default selected.
            Step 11:   Click on More → Link to source data check box. This will link the data consolidated. This option will link the
                     source data with the target data thus allowing the data updation.

































                                                                                 Electronic Spreadsheet (Advanced)  193
   188   189   190   191   192   193   194   195   196   197   198