QUESTION 4 S points You want to find the average of the three numbers in cels A2

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.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.