IF Quiz
Authored by Mieke Coetzee
Computers
12th Grade
Used 2+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
5 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Bepaal die uitslag van die volgende geneste IF-funksies:
A1 - 81
=IF(A1>=90,"A+",IF(A1>=80,"A","Nie 'n onderskeiding nie"))
90
A+
A
Nie 'n onderskeiding nie
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Bepaal die uitslag van die volgende geneste IF-funksies:
A2 - 6
=IF(A2>=20,10%,IF(A2>=10,7%,5%))
10%
7%
5%
20
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Bepaal die uitslag van die volgende geneste IF-funksies:
A3 - 156
=IF(A3>=1000,10,IF(A3>=500,15,20))
10
15
20
100
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Bepaal die uitslag van die volgende geneste IF-funksies:
A4 - 56
=IF(A4>=80,"Onderskeiding",IF(A4>=30,"Slaag","Druip"))
Onderskeiding
Slaag
Druip
#VALUE
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Bepaal die uitslag van die volgende geneste IF-funksies:
A5 - 34
=IF(A5>=50,"1ste Goud",IF(A5>=40,"2de Goud",IF(A5>=30,"Silwer","Brons")))
1ste Goud
2de Goud
Silwer
Brons
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?
