IF, OR, AND, Left, Right, and Left
Quiz
•
Computers
•
11th Grade
•
Hard
Khuon Ratha
Used 2+ times
FREE Resource
Enhance your content
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Choose the correct answer below: A2>=30
A2ធំជាងឬស្មើរ30
A2តូចជាងឬស្មើរ30
A2ធំជាង30
A2តូចជាង30
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
True/False: =IF(A2>=30,"B",IF(A2>=25,"C",""))
True
False
3.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
Choose 3 incorrect answers below: =OR () Function
=IF(OR(A3=18,B3="Female"),100,"")
=IF(OR(A3=18),(B3="Female"),100,"")
=IF(OR(A3=18,B3="Female")100,"")
=IF(OR(A3=18,B3="Female")100)
4.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
Choose 3 correct answers below: =AND ()
=IF(AND(B3="Male", C3=20),100,0)
=IF(AND(B3="Male", C3=20),100,"")
=IF(AND(B3="Male", C3=20),100)
=IF(AND(B3=Male, C3=20),100,0)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
TRUE/FALSE: =AND(1=1,2=2,3=3)
TRUE
FALSE
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
TRUE/FALSE: =AND(1=2,2=3,3=4)
TURE
FALSE
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
TRUE/FALSE: =OR(1=2,2=3)
TRUE
FALSE
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
%20(1).png)
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
Similar Resources on Wayground
10 questions
Variables and Data Types
Quiz
•
10th - 12th Grade
15 questions
BTEC L2 Unit 1 Online World 1-8
Quiz
•
11th - 12th Grade
15 questions
Chapter : 9 Working with tables
Quiz
•
5th Grade - University
15 questions
Graphic properties
Quiz
•
10th - 11th Grade
10 questions
Kisi-kisi UTS
Quiz
•
9th - 12th Grade
12 questions
Spreadsheets Quiz
Quiz
•
9th - 12th Grade
10 questions
Email Quiz - PWHS
Quiz
•
1st - 12th Grade
10 questions
Health and Safety - Creative iMedia
Quiz
•
11th Grade
Popular Resources on Wayground
10 questions
Ice Breaker Trivia: Food from Around the World
Quiz
•
3rd - 12th Grade
20 questions
MINERS Core Values Quiz
Quiz
•
8th Grade
10 questions
Boomer ⚡ Zoomer - Holiday Movies
Quiz
•
KG - University
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
Adding Integers
Quiz
•
6th Grade
20 questions
Multiplying and Dividing Integers
Quiz
•
7th Grade
10 questions
How to Email your Teacher
Quiz
•
Professional Development
15 questions
Order of Operations
Quiz
•
5th Grade
