Question

write the step to outline data using subtotals
​

Answer 1

If the amount of data in your worksheet becomes overwhelming, creating an outline can help. Not only does this allow you to organize your data into groups and then show or hide them from view, but it also allows you to summarize data for quick analysis using the Subtotal command (for example, subtotaling the cost of office supplies depending on the type of product).

In this lesson, you will learn how to outline your worksheet in order to summarize and control how your data is displayed.

Mark me as brainliest

Answer 2

steps as follow :

1. First, sort your worksheet by the data you want to subtotal. ...

2. Select the Data tab, then click the Subtotal command

3. The Subtotal dialog box will appear. ..

4. Click the drop-down arrow for the Use function: field to select the function you want to use

.