In Quizzes sheet, apply Subtotal tool to data in the sheet. The result must be grouped by Student Name. The Subtotal tool should calculate the average of quizzes for each student. What is the average of the student "John"? Write the answer in the answer box.

Which tool is used to control data entry in Excel?

What functions that Subtotal tool can perform? Select all correct choices.

Subtotal tool is more powerful than PivotTable tool.

Subtotal and PivotTable tools share some features.

In Data Entry sheet, which of the following data can be entered in Income column? Select all correct choices.

In Data Entry sheet, we can enter the word "Teacher" in the Occupation column.

Insert a PivotTable in a new sheet for the data in the Assessments sheet. Select all fields to be added to the PivotTable. In Values section, change the Sum to Average for all fields. The PivotTable should be grouped by student name by default. Format the result of each Average to be Number with one decimal place. What is the Average of Total for "Kevin"?

Write your answer in the answer box.

In using Subtotal tool, the column of grouped data should be sorted.

Subtotal tool can calculate only the sum of grouped data.