OOPS! You made a mistake while creating Subtotal in Excel. Which of the following is the fastest and easiest way to remove all Subtotal features?Group of answer choicesClick on Subtotal under Outline group and click "Remove All" button. Simply add a new set of correct subtotals, then hide the incorrect ones.Write down the current subtotals on a piece of paper, then delete/restore the subtotals one by one until you find your error. Then delete all the remaining subtotals making sure to keep the proper values in the new subtotals as you go.It is hard to remove Subtotal features, so continue working without removing them even though the data might be inaccurate.

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

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

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