Which of the following is a Logical Function in Excel?

Question

Which of the following is a logical function in excel?

1. IF
2. SUMIF
3. LOGIF
4. COUNTIF
5. FIND

Answer

A. IF

Explanation

A logical function in excel is a function that produces a logic value (TRUE or FALSE).

You can actually see the list of logical functions available in excel in your excel file if you want. To do that, go to the Formulas tab in your Excel ribbon and click on the “Logical” dropdown button there.



Among the functions in our five answer choices, only IF is in that logical functions list. Thus, the correct answer here is A.

Go back to the Compute Expert's excel quiz page