Study the worksheet below: of Student 1 Student 2 Class Average Projects (25%) Participation (25%) Quizzes (25%) * Final Exam (25%) Final Mark 58.28% 66.56% 22.56% 78,55% 56.49% 93,17% 100.00% 98.50% 98.50% 59.27% 73.23% 18.72% 59.13% 62.72% 82.53% 43.06% 69.86% 59.97% 81.60% 52.52% 81.30% 66.68% 80.78% 47.07% 77.47% Answer the following questions: (a) Write the complete formula (it should be the most efficient) that has been added to cell B6 (4) (b) What is the name of the tool that can be used to complete cells D1:F1 so that the labels continue e.g. Student 3, Student 4, Student 5 Describe how you would apply this tool. (3) (c) Explain why functions are frequently used in Spreadsheet formulas and identify the function used to find a value in a table/range? (3) 1 A T: F ili III E % &? (a) (b) (c)