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. The PivotTable must be grouped by Student Name. If there is any field in Filter sections move it Rows section. Design the PivotTable to Show in Tabular Form. What is the value in cell F35?

Write your answer in the answer box.

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. Change the PivotTable to be grouped by Course Code instead of Student Name. What is the Average of MATH01 course?

Write your answer in the answer box.

In Data Entry sheet, the Source of the list in the Occupation column is written directly in the Source field.

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.

In Data Entry sheet, what is the best description for the validation rule in Age column?

Using Whole Number in Data Validation will allow to ......

In Data Entry sheet, what is the data validation rule used in CPR Number column?

Which alert in Data Validation that we cannot skip when entering invalid data?

Which message is used in Data Validation to inform the user about the valid values before entering data?

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 formula in cell C59 which is the average of Richard?