What is an IF Function?

A conditional statement that checks to see if something is true or false

Sums up a cell range if it meets certain criteria

IF Function

Authored by Joan Barr

Computers

12th Grade - Professional Development

Used 13+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

16 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which is the correct way to write this function:
IF B4 is greater than 200, show "High", otherwise, show "Low"

IF(B4>200,"High","Low")

=IF(B4<200,"High","Low")

=IF(B4>200,"High","Low")

=IF(B4>200"High","")

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which is the correct way to write this function:
IF C3 is equal to 70, show "Pass", otherwise, show "Fail"

=IF C3=70,"Pass","Fail"

=IF(C3=70,"Fail","Pass")

=IF(C3=70,Fail,Pass)

=IF(C3=70,"Pass","Fail")

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which is the correct way to write this function:
IF B7 is greater or equal to 50, show "Bonus", otherwise, show "No Bonus".

=IF(B7>=50,"Bonus","No Bonus")

IF(B7>=50,"Bonus","No Bonus")

=IF(B7>50,"Bonus","No Bonus")

=IF(B7=50,"Bonus","No Bonus")

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which is the correct way to write this function:
IF C4 is less than 75, multiply C4 by 10, otherwise, show 0.

=IF(C4<75,"Multiply 10","0")

=IF(C4<75,C4x10,0)

=IF(C4<75,C4*10,0)

=IF(C4>75,C4*10,0)

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of these symbols means "greater than"?

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In this IF function example: =IF(G8>40,"Yes","No")
What would show in the cell after you hit enter if the value in G8 was 62?

Yes

Nothing would show

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In the IF function example:
=IF(A23>=100,"Prize","No Prize")
What would show in the cell after you hit enter if the value in A23 is 89?

Prize

No Prize

Nothing would show in the cell

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

15 questions

1.1.1 The structure and function of the processor

Quiz

•

11th Grade - University

20 questions

Network topologies

Quiz

•

8th Grade - University

20 questions

WML & WAP

Quiz

•

University

20 questions

ข้อสอบปลายภาควิชาเทคโนโลยี ม.3

Quiz

•

Professional Development

13 questions

GIT COURSE

Quiz

•

University

13 questions

Stepwise Refinement

Quiz

•

11th - 12th Grade

20 questions

SPCC ISE 2 Quiz TE B

Quiz

•

University

20 questions

Software Engineering Quiz 1

Quiz

•

University

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

20 questions

Figurative Language Review

Quiz

•

6th Grade

Discover more resources for Computers

18 questions

[AP CSP] JavaScript Programming Lesson 2025-2026

Lesson

•

9th - 12th Grade

30 questions

Quiz 1 Review

Quiz

•

University

IF Function

Which is the correct way to write this function:
IF B4 is greater than 200, show "High", otherwise, show "Low"

Which is the correct way to write this function:
IF C3 is equal to 70, show "Pass", otherwise, show "Fail"

Which is the correct way to write this function:
IF B7 is greater or equal to 50, show "Bonus", otherwise, show "No Bonus".

Which is the correct way to write this function:
IF C4 is less than 75, multiply C4 by 10, otherwise, show 0.

Which of these symbols means "greater than"?

In this IF function example: =IF(G8>40,"Yes","No")
What would show in the cell after you hit enter if the value in G8 was 62?

In the IF function example:
=IF(A23>=100,"Prize","No Prize")
What would show in the cell after you hit enter if the value in A23 is 89?

Which of these symbols mean "less than"?

Which is the correct way to write this function:
IF B8 is greater than C8, show "Win", otherwise, show "Lose"

In this IF function example:
=IF(F2<30,100-F2,0)
What would show in the cell after you hit enter if the value in F2 is 29?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers

IF Function

Which is the correct way to write this function:IF B4 is greater than 200, show "High", otherwise, show "Low"

Which is the correct way to write this function:IF C3 is equal to 70, show "Pass", otherwise, show "Fail"

Which is the correct way to write this function:IF B7 is greater or equal to 50, show "Bonus", otherwise, show "No Bonus".

Which is the correct way to write this function:IF C4 is less than 75, multiply C4 by 10, otherwise, show 0.

Which of these symbols means "greater than"?

In this IF function example: =IF(G8>40,"Yes","No")What would show in the cell after you hit enter if the value in G8 was 62?

In the IF function example:=IF(A23>=100,"Prize","No Prize")What would show in the cell after you hit enter if the value in A23 is 89?

Which of these symbols mean "less than"?

Which is the correct way to write this function:IF B8 is greater than C8, show "Win", otherwise, show "Lose"

In this IF function example: =IF(F2<30,100-F2,0)What would show in the cell after you hit enter if the value in F2 is 29?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers

Which is the correct way to write this function:
IF B4 is greater than 200, show "High", otherwise, show "Low"

Which is the correct way to write this function:
IF C3 is equal to 70, show "Pass", otherwise, show "Fail"

Which is the correct way to write this function:
IF B7 is greater or equal to 50, show "Bonus", otherwise, show "No Bonus".

Which is the correct way to write this function:
IF C4 is less than 75, multiply C4 by 10, otherwise, show 0.

In this IF function example: =IF(G8>40,"Yes","No")
What would show in the cell after you hit enter if the value in G8 was 62?

In the IF function example:
=IF(A23>=100,"Prize","No Prize")
What would show in the cell after you hit enter if the value in A23 is 89?

Which is the correct way to write this function:
IF B8 is greater than C8, show "Win", otherwise, show "Lose"

In this IF function example:
=IF(F2<30,100-F2,0)
What would show in the cell after you hit enter if the value in F2 is 29?