If you want to apply Subtotals of "Unit Sold Wholesale" by "Discipline" and then "Area" columns, how many levels should you apply Sort function to the above table before applying Subtotals to present appropriate result?Group of answer choicesat least 1at least 2at least 3Excel will automatically sort for you when using the subtotal function.

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 add subtotal, what should be in "At each change in" box:Group of answer choicesSpecify sorted rowspecify filtered column Specify filtered rowSpecify sorted column

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

Which of the following are valid sorting orders you can choose when adding sorting levels to your data? Select all that apply.1 pointZ to AOldest to NewestYoungest to Oldest Smallest to Largest

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