Page 243 - Trackpad 402_Class-X_Final
P. 243

Sneak Peek                                                                         LibreOffice



                I   To Consolidate Data in LibreOffice Calc:
                   1.  Click on the ‘Data’ tab, then Click on ‘Consolidate…’ option.
























                   2.   ‘Consolidate’ dialog box appears on the screen. Type the Source data range and click on Add button to
                       insert the selected range in the Consolidate ranges.























                   3.  Choose the desired ‘Function’ and ‘Reference’ for the data.



























                                                                                 Electronic Spreadsheet (Advanced)  243
   238   239   240   241   242   243   244   245   246   247   248