IF, OR, AND, Left, Right, and Left
Quiz
•
Computers
•
11th Grade
•
Hard
Khuon Ratha
Used 2+ times
FREE Resource
Enhance your content in a minute
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
MICROSOFT EXCEL
Quiz
•
9th - 11th Grade
10 questions
Les Tableurs ( Microsoft Excel ) 1
Quiz
•
6th - 12th Grade
14 questions
S1 Spreadsheets Functions/Formulae
Quiz
•
7th - 11th Grade
10 questions
Bài 10A: Sử dụng hàm COUNTIF
Quiz
•
9th Grade - University
15 questions
Pseudocode and Flowcharts - Computer Science
Quiz
•
KG - 12th Grade
13 questions
Python Fundamentals and Programming
Quiz
•
11th - 12th Grade
15 questions
Bebras Colage B
Quiz
•
7th - 12th Grade
10 questions
Computational Thinking
Quiz
•
9th - 11th Grade
Popular Resources on Wayground
10 questions
Ice Breaker Trivia: Food from Around the World
Quiz
•
3rd - 12th Grade
20 questions
Halloween Trivia
Quiz
•
6th - 8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
4 questions
Activity set 10/24
Lesson
•
6th - 8th Grade
22 questions
Adding Integers
Quiz
•
6th Grade
10 questions
How to Email your Teacher
Quiz
•
Professional Development
15 questions
Order of Operations
Quiz
•
5th Grade
30 questions
October: Math Fluency: Multiply and Divide
Quiz
•
7th Grade
