Page 244 - Trackpad 402_Class-X_Final
P. 244
4. Click on ‘OK’ button.
II To Create Subtotal in LibreOffice Calc:
1. Select the range of cells with values for which 'subtotal' function needs to be implemented. Ensure
that the columns must have labels.
2. Click on ‘Data’ menu and then select ‘Subtotals…’ option. ‘Subtotals’ dialog box appears on the screen.
3. In the ‘Group by’ box, select the column for which subtotal is required. If the contents of the selected
column change, the subtotals are automatically recalculated.
4. In the ‘Calculate subtotals for’ box, select the columns containing the values to subtotal.
5. In ‘Use function’ box, select the desired function to calculate the subtotals.
6. Click on the ‘OK’ button.
244 Trackpad Information Technology-X

