Question

write the steps creating subtotals​

Answer 1

Answer:

answer is

Explanation:

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

Select the Data tab, then click the Subtotal command.

The Subtotal dialog box will appear. ...

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

Answer 2

Explanation:

You can automatically calculate subtotals and grand totals in a list for a column by using the Subtotal command.

Important: Subtotals are not supported in Excel tables. The Subtotal command will appear grayed out if you are working with an Excel table. To add subtotals in a table, you must first convert the table to a normal range of data, and then add the subtotal. Note that this will remove all table functionality from the data except table formatting. Or you can create a PivotTable.

When you insert subtotals:

Subtotals are calculated with a summary function, such as Sum or Average, by using the SUBTOTAL function. You can display more than one type of summary function for each column.

Grand totals are derived from detail data, not from the values in the subtotals. For example, if you use the Average summary function, the grand total row displays an average of all of the detail rows in the list, not an average of the values in the subtotal rows.

Example of automatic subtotals

If the workbook is set to automatically calculate formulas, the Subtotal command recalculates subtotal and grand total values automatically as you edit the detail data. The Subtotal command also outlines the list so that you can display and hide the detail rows for each subtotal