QUESTION 1 (10 Marks) (a) Briey explain what is a nested lF function. (b) Students taking French will be awarded a Merit if their marks are at least 80 marks, a Pass if their marks are between 50 (inclusive) and less than 80, or an Ungraded grade if their marks are less than 50. Write a Nested IF function in cell 32, which can be copied to cell B3 through B4 to generate the results shown in Table 1 below. 1 Marks Grade 0 I Ungraded II 50 Pass 80 Merit Table 1 (c) Using the E function, write the function in cell 02, which can be copied to cell C3 through cell 04 to generate the same results in question 1(b). QUESTION 2 (10 Marks) (a) In June 2020, a study was conducted to examine the amount of time teenagers spent on online gaming. 500 polytechnic students were selected for this study and each student's online gaming duration was measured automatically with a special gadget. A preview of the data collected is shown in Table 2 below. 1 2 3 4 s. 6. 7. 8 Table 2 (i) State the Excel function and syntax you would key in to nd the number of students who spent at least 360 minutes on online gaming per day. (ii) State the Excel function and syntax you would key in to nd the average amount of time spent on online gaming by United Polytechnic students. (b) What is the difference between Wand Mug