Logical Functions

What are logical functions used for in spreadsheets?

• To perform calculations

• To test whether a situation is true or false

• To display information

• All of the above

Which function is used for decision making in spreadsheets?

• AND

• OR

• NOT

• IF

What is the format of the IF function?

• =IF(condition, true, false)

• =IF(condition, false, true)

• =IF(true, condition, false)

• =IF(false, condition, true)

What does the AND function do?

• Returns TRUE if any of the conditions are met

• Returns TRUE only if all of the conditions are met

• Returns FALSE if any of the conditions are met

• Returns FALSE only if all of the conditions are met

What does the OR function do?

• Returns TRUE if any of the conditions are met

• Returns TRUE only if all of the conditions are met

• Returns FALSE if any of the conditions are met

• Returns FALSE only if all of the conditions are met

What does the NOT function do?

• Returns the logical opposite of the condition test

• Returns TRUE if any of the conditions are met

• Returns TRUE only if all of the conditions are met

• Returns FALSE if any of the conditions are met

What is the purpose of the IFERROR function?

• To perform calculations

• To display alternative text or values when an error occurs

• To test whether a situation is true or false

• To compare more than one condition

What is the result of a logical test in Excel?

• TRUE

• FALSE

• Both TRUE and FALSE

• Neither TRUE nor FALSE

What is the purpose of nesting IF functions?

• To perform calculations

• To test whether a situation is true or false

• To compare more than one condition

• To make more than one decision before calculating an answer

What is the purpose of the IF function in Excel?

• To perform calculations

• To test whether a situation is true or false

• To display information

• All of the above