Question

where can we use the subtotals features to subtotal data​

Answer 1

Answer:

Excel has a Subtotal feature that automatically inserts SUBTOTAL formulas in sorted data. You can find this feature at Data > Outline > Subtotal. SUBTOTAL formulas inserted this way use the standard function numbers 1-11.

Function: Include hidden

AVERAGE: 1

VARP: 11