Page 158 - Computer - 10(A&B)
P. 158
Your data must be correctly sorted before using
the Subtotal option.
Follow these steps to add subtotals to a list in a worksheet:
Step1: Open the worksheet containing the data.
Step 2: Select and sort the list on the field for which you want subtotals inserted using the Sort option from the
Data menu. For example, select Region from the list.
Step 3: Click on Subtotals option from the Data menu.
40