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
   239   240   241   242   243   244   245   246   247   248   249