✅ 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. 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.
Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!