IF Function

12th Grade - Professional Development

•

16 Qs

Similar activities

Python List

4th Grade - University

•

15 Qs

logica excel

1st Grade - University

•

21 Qs

1.1.1 The structure and function of the processor

11th Grade - University

•

15 Qs

Network topologies

8th Grade - University

•

20 Qs

WML & WAP

University

•

20 Qs

Microsoft Office Advandces 2016

9th Grade - Professional Development

•

20 Qs

Software Engineering Quiz 1

University

•

20 Qs

Arduino Loop

2nd Grade - University

•

20 Qs

IF Function

Quiz

•

Computers

•

12th Grade - Professional Development

•

Practice Problem

•

Medium

Joan Barr

Used 11+ times

FREE Resource

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

Create a free account and access millions of resources

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

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?

Similar Resources on Wayground

16 questions

Algo Quiz

Quiz

•

University

19 questions

Informatika Kelas 5 Bab 2

Quiz

•

5th Grade - University

20 questions

Ինֆորմատիկա 10 II կիսամյակի ամփոփիչ աշխատանք

Quiz

•

10th - 12th Grade

20 questions

ตอบปัญหาคอมพิวเตอร์st

Quiz

•

9th - 12th Grade

11 questions

Cascading Style Sheets

Quiz

•

8th - 12th Grade

20 questions

COA_QUIZ_UNIT I

Quiz

•

University

12 questions

PSSI Chp 1 dan 2

Quiz

•

University

20 questions

Pengayaan Informatika

Quiz

•

12th Grade

Popular Resources on Wayground

10 questions

Honoring the Significance of Veterans Day

Interactive video

•

6th - 10th Grade

9 questions

FOREST Community of Caring

Lesson

•

1st - 5th Grade

10 questions

Exploring Veterans Day: Facts and Celebrations for Kids

Interactive video

•

6th - 10th Grade

19 questions

Veterans Day

Quiz

•

5th Grade

14 questions

General Technology Use Quiz

Quiz

•

8th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

15 questions

Circuits, Light Energy, and Forces

Quiz

•

5th Grade

19 questions

Thanksgiving Trivia

Quiz

•

6th Grade

Discover more resources for Computers

15 questions

AP CSP Unit 4

Quiz

•

10th - 12th Grade

45 questions

Cybersecurity Quiz

Quiz

•

12th Grade

23 questions

Prog 1 Python Q1 Practice

Quiz

•

9th - 12th Grade

IF Function

16 questions

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?

Create a free account and access millions of resources

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers

IF Function

16 questions

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?

Create a free account and access millions of resources

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?