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.