Question

Which terms are used in conditional logic functions? Choose all that apply

WHEN
IF
OR
NOR
IFTRUE
IFERROR

Answer 1

The correct option to this question can be given as:

• IF
• IFERROR

Explanation:

The above options are used in the conditional logic function that is available in Microsoft Excel. In excel this function is used for creating a conditional equation and it is normally used to check several tasks and make a logical decision between them. and other options are wrong that can be described as:

• WHEN and IFTRUE conditions are used in the programming language. for example C, C++, SQL.
• OR and NOR is used in boolean operator function in excel, It will return only true or false value.