What will be the output of the MS Excel formula =COUNTIF(A1:A4, 10) if cell entries are A1=5, A2=10, A3=15, and A4=20?

Question

What will be the output of the MS Excel formula =COUNTIF(A1:A4, >10) if cell entries are A1=5, A2=10, A3=15, and A4=20?

Team JKSSB Mock Tests · Accepted Answer

The formula filters for numbers strictly greater than 10. Out of the given values, 15 and 20 satisfy the condition, so the function returns 2.

What will be the output of the MS Excel formula =COUNTIF(A1:A4, >10) if cell entries are A1=5, A2=10, A3=15, and A4=20? MCQ with Answer and Explanation