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

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.

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

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

Given a spreadsheet containing five columns:SuburbStatePostcodeQuantityIf you'd like to create a subtotal based on Quantity for each State, then you'll need to Blank 1 Question 5 by Blank 2 Question 5 , before running Subtotal.

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