Y8 Lesson 5: Excel IF Function Revision

Excel Revision
(IF Function)

Excel Revision
(IF Function)

Multiple Choice

If function allows to choose between two actions based on whether the condition is true or ..................

• false

• 1

• Yes

• -1

Multiple Choice

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

• IF (logical_test, value_if_true, value_if_false)

• =IF (logical_test, value_if_true, value_if_false)

• =(logical_test, value_if_true, value_if_false)

• IF(value_if_true, value_if_false, logical_test)

Multiple Choice

If the cell B2 is 68, what will this IF function give you as a result?

=IF (B2>60, "pass", "fail")

• pass

• fail

• 60

Multiple Choice

=IF(B5>B4, "Large", "Small")

The value in B5 = 56

The value in B4 = 89

What is the result that this IF statement will return?

• Large

• Small

Multiple Choice

What is the purpose of the IF statement in Excel?

• Formatting cells

• Performing calculations

• Displaying data labels

• Making logical comparisons

Multiple Choice

In an IF statement, what is the purpose of the "logical_test" parameter?

• It defines the value if the condition is true.

• It defines the value if the condition is false.

• It specifies the condition to be evaluated.

• It determines the formatting of the result.

Multiple Choice

What will happen if A1=2 in the following IF statement?

=IF(A1>10, "High", "Low")

• High

• Low

• True

• False

Multiple Choice

Which Excel function can be used as the "value_if_true" or "value_if_false" argument in an IF statement to perform another calculation?

• SUM

• AVERAGE
  

• COUNT

• Any mathematical function

Multiple Choice

What does the following IF statement do?

=IF(B2="Yes", "Approved", "Rejected")

• Adds "Yes" to cell B2.

• Checks if cell B2 is equal to "Yes" and returns "Approved" if true, otherwise "Rejected".

• Checks if cell B2 is empty and returns "Approved" if true, otherwise "Rejected".

• Checks if cell B2 is equal to "Approved" and changes it to "Rejected".

Multiple Choice

Which logical operator is employed in an IF statement to determine whether a value is greater than or equal to another value?

• ==

• <>

• !=

• >=