
IFS-Charts
Quiz
•
Information Technology (IT)
•
University
•
Practice Problem
•
Hard
Martina Bishay
FREE Resource
Enhance your content in a minute
9 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
1. What is the correct syntax of the IF function in Excel?
IF(condition, value_if_true, value_if_false)
IF(condition; value_if_true; value_if_false)
IF(condition: value_if_true: value_if_false)
IF(value_if_true, value_if_false, condition)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What will =IF(5>3, "Yes", "No") return?
5
Yes
No
Error
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does this formula do? =IF(A1>10, "High", "Low")
Displays "High" if A1 is less than 10
Displays "Low" if A1 is greater than 10
Displays "High" if A1 is greater than 10, otherwise "Low"
Always displays "High"
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following formulas correctly uses nested IFs?
=IF(A1>90, "A", IF(A1>80, "B", "C"))
=IF(A1>90 "A" IF(A1>80 "B" "C"))
=IF((A1>90, "A"), (A1>80, "B", "C"))
=IF A1>90, "A", IF A1>80, "B", "C"
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the role of the AND function in an IF formula?
Checks if any condition is true
Returns the first false condition
Checks if all conditions are true
Sorts data
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What will this formula return if A1 = "Yes" and B1 = 80?
=IF(AND(A1="Yes", B1>=75), "Approved", "Denied")
Approved
Denied
Error
Nothing
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which chart is most suitable for showing trends over time?
A) Bar Chart
B) Line Chart
C) Pie Chart
D) Doughnut Chart
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
CHFI Module 1
Quiz
•
University
10 questions
Animation Techniques Quiz
Quiz
•
10th Grade - University
10 questions
ADBM_Quiz_2_C
Quiz
•
University
12 questions
Aula07 - Matrizes
Quiz
•
University
11 questions
JavaEE-servlets-jsp
Quiz
•
University
10 questions
Web программалау бөліміне қысқаша шолу
Quiz
•
10th Grade - University
10 questions
Diagnóstico de Algoritmos y Fundamentos de Programacion
Quiz
•
University
10 questions
Tin 9 Bài 8. Hàm SUMIF
Quiz
•
9th Grade - University
Popular Resources on Wayground
8 questions
2 Step Word Problems
Quiz
•
KG - University
20 questions
Comparing Fractions
Quiz
•
4th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
Latin Bases claus(clois,clos, clud, clus) and ped
Quiz
•
6th - 8th Grade
22 questions
fractions
Quiz
•
3rd Grade
7 questions
The Story of Books
Quiz
•
6th - 8th Grade
Discover more resources for Information Technology (IT)
8 questions
2 Step Word Problems
Quiz
•
KG - University
7 questions
Comparing Fractions
Interactive video
•
1st Grade - University
7 questions
Force and Motion
Interactive video
•
4th Grade - University
10 questions
14.2 Independent/Dependent Variables
Quiz
•
KG - University
18 questions
Great Lakes States
Quiz
•
KG - University
7 questions
DNA, Chromosomes, Genes, and Traits: An Intro to Heredity
Interactive video
•
11th Grade - University
7 questions
Reflexive Verbs in Spanish
Lesson
•
9th Grade - University
7 questions
Narrative Writing 1
Interactive video
•
4th Grade - University
