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
Working with tables
Quiz
•
5th - 12th Grade
10 questions
E-Tech Lesson 1
Quiz
•
11th Grade
11 questions
Cascading Style Sheets
Quiz
•
8th - 12th Grade
15 questions
REVISION-Primary & Secondary Storage
Quiz
•
10th - 11th Grade
14 questions
1.1 Data and information
Quiz
•
10th - 12th Grade
20 questions
Online Platform Block Q
Quiz
•
11th - 12th Grade
15 questions
Chapter 3: Storage devices and media (Part 2):
Quiz
•
10th - 11th Grade
11 questions
What is a computer
Quiz
•
KG - 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
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
