Question

What are the two ways to implement subtotals?​

Answer 1

There are two steps to follow when we wish to use the SUBTOTAL function. These are: Formatting and sorting of the provided Excel data. Applying SUBTOTAL to the table.

How to use the SUBTOTAL Function in Excel?

There are two steps to follow when we wish to use the SUBTOTAL function. These are:

Formatting and sorting of the provided Excel data.

Applying SUBTOTAL to the table.

Let’s understand this Excel function with the help of an example. We use data provided by a garment manufacturer. He manufactures T-shirts of five different colors, i.e., White, Black, Pink, Green, and Beige. He produces these T-shirts in seven different sizes, i.e. 2, 4, 6, 8, 10, 12, 14.

Hopefully it helps

PLS Mark Me As Brainliest

Answer 2

Explanation:

Apply the First Subtotal

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.