Answer:One of the lesser-known features of Excel is its ability to automatically generate subtotals on multiple levels using the application's Subtotal feature. If you keep sales figures in your worksheet, for example, you can create subtotals for sales in each region, plus nested subtotals broken down by state and even city. To implement multiple-level subtotals, first use Excel's advanced sorting function to rearrange your data into the right grouping levels.
Explanation: