# Question: 7 a what is the syntax of a basic if...

###### Question details

7.)

a.

What is the syntax of a basic IF statement in Excel?

IF(logical test) |
||

IF(logical test, value if true) |
||

IF(logical test, value if true, value if false) |
||

IF(logical test, value if false, value if true) |

b.

True or False? “AND” means that only one of the logical test must be true in order for the statement to return a value of TRUE.

True

False

c.

What is the purpose of the IF function?

It is a logical function that displays organized data if certain criterion are met. |
||

It is a logical function that always displays the value of TRUE or FALSE in a cell. |
||

It is always a data formatting function. |
||

It is a logical function that allows the user to specify results based on whether or not a specific criterion is true. |