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

7.)

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)

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

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.