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

