Task-2 Excel Logical Conditions
Authored by Mohamed Nabil
Computers
8th Grade
Used 21+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
21 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the syntax of the IF function in Excel?
=IF(logical_test, value_if_false, value_if_true)
=IF(logical_test, value_if_true, value_if_false)
=IF(logical_test, value_if_true)
=IF(logical_test, value_if_false)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you use nested IF statements in Excel?
By using the MAX function
By placing one IF function inside another IF function as the value_if_true or value_if_false arguments.
By using the AVERAGE function
By using the SUM function
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What are the logical operators used in Excel?
TRUE, FALSE, MAYBE
AND, OR, NOT
PLUS, MINUS, MULTIPLY
IF, ELSE, THEN
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Explain the usage of the AND function in Excel with an example.
The AND function in Excel is used to calculate the average of specified cells.
The AND function in Excel is used to find the maximum value in a range of cells.
The AND function in Excel is used to format the text in a cell.
The AND function in Excel is used to check if all the specified conditions are true.
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How do you use the countif function in Excel?
You use the COUNTIF function in Excel by entering the maximum value of cells and the criteria you want to count.
You use the COUNTIF function in Excel by entering the sum of cells and the criteria you want to count.
You use the COUNTIF function in Excel by entering the average of cells and the criteria you want to count.
You use the COUNTIF function in Excel by entering the range of cells and the criteria you want to count.
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
When would you use the IF function in Excel?
To change the font style of a cell
To perform a logical test and return different values based on the result.
To calculate the average of a range of cells
To insert a new row in the spreadsheet
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the difference between AND and OR functions in Excel?
The AND function returns TRUE if any of the conditions are TRUE, while the OR function returns TRUE if all the conditions are TRUE.
The AND function returns FALSE if all the conditions are TRUE, while the OR function returns FALSE if any of the conditions are TRUE.
The AND function returns TRUE if all the conditions are TRUE, while the OR function returns TRUE if any of the conditions are TRUE.
The AND function returns TRUE if all the conditions are TRUE, while the OR function returns FALSE if any of the conditions are TRUE.
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
16 questions
Robotic /coding exam
Quiz
•
6th - 8th Grade
21 questions
CÂU HỎI ÔN TAP HKI
Quiz
•
5th Grade - University
20 questions
ptscod
Quiz
•
8th Grade
18 questions
software engineering quiz
Quiz
•
KG - University
19 questions
Evaluación 9° - Tecnología e Informática - 2PER - AJSG
Quiz
•
6th - 8th Grade
20 questions
MS Excel Grade 6
Quiz
•
6th - 10th Grade
20 questions
Microsoft Excel
Quiz
•
KG - Professional Dev...
17 questions
Basic Docs
Quiz
•
8th - 9th 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
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th 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
