Q2) Using exeel sheet function to find the result of the following question. You can use multiple cells but you are not allowed to use VBA In this question. 3. Column A and column B contains test 1...

60",B.B,">60") b. Cells Al, BI and Cl contains the grades of test 1, test 2 and test 3 respectively, find the average of the maximum 2 grades if the student [passed all tests, otherwise write fail if the student fail any test, Passing grade is 60. b. Find the percentage of negative numbers in the first five rows of columns B to G. d. Find the value of y from the following equation, take x value from the cell A2. xー3.4 x>4 "/>
Extracted text: Q2) Using exeel sheet function to find the result of the following question. You can use multiple cells but you are not allowed to use VBA In this question. 3. Column A and column B contains test 1 and test 2 grades. Write excel sheet function to find the number of students who passed both tests. Countiti A A,">60",B.B,">60") b. Cells Al, BI and Cl contains the grades of test 1, test 2 and test 3 respectively, find the average of the maximum 2 grades if the student [passed all tests, otherwise write fail if the student fail any test, Passing grade is 60. b. Find the percentage of negative numbers in the first five rows of columns B to G. d. Find the value of y from the following equation, take x value from the cell A2. xー3.4 x>4