Question

Subtotal function listed under _________ category.

Answer 1

Answer:

DATA IS A RIGHT ANSWER

DATA

DATA

Answer 2

Answer:

The answer to the given question is:

Data

Explanation:

Before you can apply a subtotal, you need to sort the data by the column on which the subtotal is based. In this example, Category and Product are subtotaled, so the data is sorted by these two columns.

Before applying a subtotal, you need to sort the data by the column on which the subtotal is based. In this example, Category and Product are included, so the data is sorted by these two columns.

Sort the data

Apply the first subtotal

After sorting the data, perform the following steps to apply the first subtotal. In this example, the Category column is included first.

Select a cell from the list, click the Data tab on the Excel ribbon, then click Subtotal.

In the To change field, select the first column (category in this example) on which the subtotal is based.

Select the function to use when summing columns.

Select all columns for which a subtotal is required.

Turn off Replace current subtotal (if there are no existing subtotals to delete).

Enables or disables pagination and summarization under the data options, depending on your settings.

Click OK to apply the subtotal.

#SPJ3