The first step when using the Subtotal command is to_____________.Group of answer choicesSort the list.Open the Subtotal dialog box.Insert blank rows between each data group.Select the function used to calculate the subtotals.

When using the subtotal function, you can calculate what values?Group of answer choicesSumAverageMinimumAll of the Above

To add subtotal, what should be in "At each change in" box:Group of answer choicesSpecify sorted rowspecify filtered column Specify filtered rowSpecify sorted column

To remove the subtotals, which option would you choose from the Subtotal dialog box?Group of answer choicesSummary below dataRemove AllCancelReplace current subtotals

Which of the following can be done to insert two levels of subtotals to a data.Group of answer choicesOpen the Subtotal window and add both levels of Subtotal at the same timeOpen the Subtotal window and add the Subtotal for Primary Category Open the Subtotal window a second time and add Subtotal for the Secondary CategoryOpen the Subtotal window and add the Subtotal for Secondary Category Open the Subtotal window a second time and add Subtotal for the Primary CategoryAll of the above

True or false? In the Subtotal dialog box, if the Summary below data box is unchecked, the Grand Total and Subtotal appear above the data.Group of answer choicesTrueFalse