When using the subtotal function, you can calculate what values?Group of answer choicesSumAverageMinimumAll 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.

Use the SUMIF function when you want to:Group of answer choicesDisplay the sum of a range only if the answer is a positive numberCalculate and display the sum of a range only if it meets specific criteriaDisplay the larger of the sums of two rangesFind sum pi

Which function can be used to calculate the average of a range of values in Excel?Group of answer choicesSUMAVERAGECOUNTMAX

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

Select the correct answerWhich one is the aggregate functions used in queries ?OptionsMINAll of the mentionedSUMAVGCOUNTNone of the mentionedMAX