Computer Science, asked by anaisha1129, 3 days ago

what are the required inputs in the subtotal dialog box in excel
difine it long answer question​

Answers

Answered by Anonymous
3

\huge\colorbox{lightyellow}{⛄ƛNSWEƦ✺᭄}

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.

Answered by himanshi5264
2

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

Similar questions