Insert a PivotTable in a new sheet for the data in the Assessments sheet. Select...
✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
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.
Want instant access to all verified answers on moodle.polytechnic.bh?
Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!