what are the required inputs in the subtotal dialog box in excel
difine it long answer question
Answers
To insert an automatic page break after each subtotal, select the Page break between groups box.
To display a summary row above the details row, clear the Summary below data box. To show a summary row below the details row, select this check box (usually selected by default).
To overwrite any existing subtotals, keep the Replace current subtotals box selected, otherwise clear this box.
Finally, click the OK button. The subtotals will appear below each data group, and the grand total will be added to the end of the table.
The subtotals are added.
Once subtotals are inserted in your worksheet, they will recalculate automatically as you edit the source data.
Answer:
To insert an automatic page break after each subtotal, select the Page break between groups box.
To display a summary row above the details row, clear the Summary below data box. To show a summary row below the details row, select this check box (usually selected by default).
To overwrite any existing subtotals, keep the Replace current subtotals box selected, otherwise clear this box.
Finally, click the OK button. The subtotals will appear below each data group, and the grand total will be added to the end of the table.
The subtotals are added.
Once subtotals are inserted in your worksheet, they will recalculate automatically as you edit the source data.
I hope it helps you...
Pl.mark as brainlist