Page 195 - Trackpad 402_Class-X_Final
P. 195

To insert Subtotals values into a worksheet, follow the steps given below:
            Step 1:   Select the range of cells. Ensure that the column labels are created and selected in the range. In the above
                    sheet the range is B2:D17.
            Step 2:  Click on Data menu and select Subtotals option. The Subtotals dialog box opens.
































            Step 3:   Select the CLASS option from the Group by drop-down menu.
            Step 4:  Select STRENGTH check box in the Calculate subtotal for box.
            Step 5:   Select the Sum function from the Use function box if not selected by default.

            Step 6:   Click on OK button.









































                                                                                 Electronic Spreadsheet (Advanced)  195
   190   191   192   193   194   195   196   197   198   199   200