Question

4. Which operation is a must before using Data Subtotal command?
Data Sort
Data Filter
Formatting
Pivot Table​

Answer 1

Answer:

(A)

Explanation:

Apply the First Subtotal

After the data is sorted, follow these steps to apply the first subtotal. In this example, the Category column will be subtotalled first.

Select a cell in the list, and on the Excel Ribbon, click the Data tab, then click Subtotals.

In the "At each change in" box, select the first column that you want to base the subtotals on -- Category in this example.

Select the function that you want to use when totaling the columns.

Select all the columns in which you want a subtotal.

Remove the check mark from "Replace current subtotals" (unless there are existing subtotals that you want to remove).

Check or uncheck the page break and summary below data options, based on your preferences.Click OK, to apply the Subtotals.

Hope this helps