Logical Functions
Authored by Tak Cheung
Computers
11th Grade
Used 6+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What are logical functions used for in spreadsheets?
To perform calculations
To test whether a situation is true or false
To display information
All of the above
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function is used for decision making in spreadsheets?
AND
OR
NOT
IF
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the format of the IF function?
=IF(condition, true, false)
=IF(condition, false, true)
=IF(true, condition, false)
=IF(false, condition, true)
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the AND function do?
Returns TRUE if any of the conditions are met
Returns TRUE only if all of the conditions are met
Returns FALSE if any of the conditions are met
Returns FALSE only if all of the conditions are met
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the OR function do?
Returns TRUE if any of the conditions are met
Returns TRUE only if all of the conditions are met
Returns FALSE if any of the conditions are met
Returns FALSE only if all of the conditions are met
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the NOT function do?
Returns the logical opposite of the condition test
Returns TRUE if any of the conditions are met
Returns TRUE only if all of the conditions are met
Returns FALSE if any of the conditions are met
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of the IFERROR function?
To perform calculations
To display alternative text or values when an error occurs
To test whether a situation is true or false
To compare more than one condition
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
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
10 questions
Review Quiz #2- Productivity Tools
Quiz
•
11th - 12th Grade
10 questions
Anime
Quiz
•
KG - University
10 questions
TIN 11 - PYTHON - PHÉP TOÁN - BIỂU THỨC - CÂU LỆNH GÁN
Quiz
•
11th Grade
10 questions
PERFORMANCE TASK 3 |EMP Tech LC2
Quiz
•
11th Grade
10 questions
JSPS Competition Hackathon - Scratch Language - Grade 1
Quiz
•
2nd Grade - University
10 questions
Microcontroller
Quiz
•
11th Grade - University
14 questions
Input, output and storage de
Quiz
•
8th Grade - Professio...
13 questions
A+ Chapter 8
Quiz
•
11th Grade
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
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
