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

