QUESTION 4 S points You want to find the average of the three numbers in cels A2
ID: 400139 • Letter: Q
Question
QUESTION 4 S points You want to find the average of the three numbers in cels A2, AB and A4. What is the comect syntax to use a function to caiculate the average? average of MEANA: QUESTION 5 5 points You need to compare twenumbers in cels A2 and 02 and find the higher number which of these formulas Wll NOT reburn the cerrect answer? formulas w IF(A2-B2A282) QUESTION 6 5 points in the following function, what does the 5 indicate? Retum the value in the 5th column of the worksheet Retum the value in the 12h column of the worksheet. Retum the value in the 5th row of the worksheet O Returm the value in th 12th row of the worisheet.Explanation / Answer
4. Correct syntax to find average of three numbers in cell A2, A3 and A4 is =AVERAGE(A2:A4)
5. To compare two numbers A2 and B2 and find the higher number the formula that will not return correct answer is =IF(B2>A2,A2,B2) because the second element of the function is returned when the logic is True which in this case is the smaller number.
6. In the following function, 5 indicates =HLOOKUP("Q4",A8:E12,5) Here 5 indicates the row number of the array table from which the data will return corresponding to the matched column in which the value "Q4" lies in the table.