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?

• ==

• <>

• !=

• >=

Fill in the Blanks

Scenario: You're calculating the shipping cost based on the weight in cell G2. If the weight is less than 10 kg, the cost is $5; otherwise, it's $10.

Fill in the Blanks

Scenario: You want to display "Pass" if the score in cell A1 is greater than or equal to 50, otherwise display "Fail".

Fill in the Blanks

Scenario: You need to calculate a commission based on sales in cell F6. If sales are above $1000, the commission is 10% of sales; otherwise, no commission is earned and "0" should be displayed.

Fill in the Blanks

Scenario: You're calculating a bonus for employees in cell A1 based on their performance rating. If the rating is "Excellent," assign a bonus of $1000; otherwise, assign a bonus of $500.

Fill in the Blanks

Scenario: You want to determine if a student is eligible for a scholarship in cell D4 based on their GPA. If the GPA is above 3.8, display "Eligible"; otherwise, display "Not Eligible".