Question

(a) Complete the following steps to calculate Sub Total

i) Select the range of cells and then choose ___________ ---->Subtotals.

ii) In the Subtotal dialog, in the _____________ box , select the column that
you want to add Subtotal to.
iii) In the Calculate Subtotals for box, select the columns containing the values

that you want to subtotal.

iv) In the ______________ box, select the function that you want to use to

calculate the subtotals

v) Click ok.


(b) How many groups can be created in a subtotals dialog box?


(c) Under which tab is the sort option available in Subtotals?​

Answer 1

The element of the following is the smallest