Question

The _______ feature generates a subtotal of the ____ of related data.​

Answer 1

Answer:

Before applying subtotals, the data must be sorted by the columns on which you want to base the subtotals. In this example, Category and Product will be subtotaled, so the data is sorted by those two columns

Answer 2

Explanation:

Formula

SUBTOTAL = (method, range1, [range2 …range_n])

Where method is the type of subtotal you wish to obtain

Range1,range2…range_n is the range of cells you wish to subtotal