Mastering Excel Logical Functions

What does the IF function do in Excel?

• The IF function adds two numbers together.

• The IF function sorts data in ascending order.

• The IF function creates a chart based on selected data.

• The IF function evaluates a condition and returns one value for true and another for false.

Which of the following is the correct syntax for the IF function?

• IF(logical_test, value_if_false)

• IF(logical_test, value_if_true, value_if_false)

• IF(value_if_false, value_if_true)

• IF(value_if_true, logical_test, value_if_false)

How can you combine IF with AND in a formula?

• IF(AND(condition1, condition2), value_if_true, value_if_false)

• AND(IF(condition1, value_if_true), condition2)

• IF(condition1 AND condition2, value_if_true)

• IF(OR(condition1, condition2), value_if_true, value_if_false)

What will the formula =IF(AND(A1>10, B1<5), 'Yes', 'No') return if A1 is 12 and B1 is 3?

• Definitely not

• No

• Yes

• Maybe

Which function would you use to check if a condition is false?

• not

• always

• true

• maybe

What is the result of the formula =IF(OR(A1=1, A1=2), 'Match', 'No Match') if A1 is 2?

• Mismatch

• No Result

• Match

• Error

How do you create a nested IF statement in Excel?

• Combine multiple IF statements into a single cell without nesting.

• Create a nested IF statement using the VLOOKUP function.

• Use the IF function within another IF function to create a nested IF statement.

• Use the SUM function within another SUM function.

What is the maximum number of nested IF functions allowed in Excel?

• 64

• 128

• 256

• 32

Which of the following is an example of using the NOT function?

• NOT A

• A AND B

• OR A

• NOT (A OR B)

In data analysis, how can logical functions enhance decision-making?

• They are primarily used for data storage.

• Logical functions enhance decision-making by enabling conditional analysis and scenario evaluation.

• Logical functions only complicate data analysis.

• Logical functions have no impact on decision-making.