Y8 Lesson 5: Excel IF Function Revision
Presentation
•
Computers
•
8th Grade
•
Practice Problem
•
Medium
SY CHONG
Used 39+ times
FREE Resource
2 Slides • 15 Questions
1
(IF Function)
2
(IF Function)
3
Multiple Choice
If function allows to choose between two actions based on whether the condition is true or ..................
false
1
Yes
-1
4
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)
5
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
6
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
7
Multiple Choice
What is the purpose of the IF statement in Excel?
Formatting cells
Performing calculations
Displaying data labels
Making logical comparisons
8
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.
9
Multiple Choice
What will happen if A1=2 in the following IF statement?
=IF(A1>10, "High", "Low")
High
Low
True
False
10
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
11
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".
12
Multiple Choice
Which logical operator is employed in an IF statement to determine whether a value is greater than or equal to another value?
==
<>
!=
>=
13
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.
Type answer...
14
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".
Type answer...
15
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.
Type answer...
16
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.
Type answer...
17
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".
Type answer...
(IF Function)
Show answer
Auto Play
Slide 1 / 17
SLIDE
Similar Resources on Wayground
11 questions
Flight Review
Presentation
•
8th Grade
12 questions
Central Idea
Presentation
•
8th Grade
12 questions
Graphing/Functions
Presentation
•
8th Grade
12 questions
KSSM Science Form 2 Chapter 10
Presentation
•
8th Grade
10 questions
Lesson 7 - Types of Software
Presentation
•
8th Grade
11 questions
Factoring General Trinomials
Presentation
•
8th Grade
11 questions
Vocab week 1
Presentation
•
8th Grade
14 questions
Computer Science History
Presentation
•
8th Grade
Popular Resources on Wayground
10 questions
Safety Day 2026 – Student Review
Quiz
•
9th Grade
21 questions
Continents and Oceans
Quiz
•
6th Grade
20 questions
Parts of Speech
Quiz
•
5th Grade
16 questions
Subject & Predicate
Quiz
•
5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
12 questions
Map Skills
Quiz
•
3rd Grade
22 questions
Continents and Oceans
Quiz
•
5th Grade
15 questions
Rounding Decimals
Quiz
•
5th Grade