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. Format the result of each Average to be Number with one decimal place. Move Course Code to Filter section. Select ENG01 from Course Code filter. What is the value in cell D16 (Grand Total for Assignment)?

Write your answer in the answer box.

Which tool is used to control data entry in Excel?

Subtotal tool is more powerful than PivotTable tool.

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

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.