IF DAN LOOKUP
Authored by TIK Talenta
Information Technology (IT)
7th Grade
Used 12+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
5 sec • 1 pt
KALAU SEL C3 BERISIKAN B, AKAN DITULISKAN BANDUNG PADA SEL D3,
KALAU BUKAN, D3 AKAN DITULISKAN JAKARTA. RUMUS PADA D3 ADALAH
=IF(C3="B";"BANDUNG")
=IF(C3="B";"BANDUNG";"JAKARTA")
2.
MULTIPLE CHOICE QUESTION
5 sec • 1 pt
KALAU SEL C3 BERISIKAN A, AKAN DITULISKAN AYAM PADA SEL D3,
KALAU BUKAN, D3 AKAN DITULISKAN BEBEK.
RUMUS PADA D3 ADALAH....
=IF(C3="A";"AYAM";"BEBEK")
=IF(C3=A;AYAM;BEBEK)
=IF(C3="A";"BEBEK";"AYAM")
3.
MULTIPLE CHOICE QUESTION
5 sec • 1 pt
KALAU SEL C3 BERISIKAN 50000, AKAN DITULISKAN MAHAL PADA SEL D3,
KALAU BUKAN, D3 AKAN DITULISKAN MURAH.
RUMUS PADA D3 ADALAH...
=IF(C3="50000";"MAHAL";"MURAH")
=IF(C3=50000;"MAHAL";"MURAH")
=IF(C3=50000;MAHAL;MURAH)
4.
MULTIPLE CHOICE QUESTION
5 sec • 1 pt
KALAU SEL C3 BERISIKAN LEBIH BESAR DAN SAMA DENGAN 50,
AKAN DITULISKAN BERAT PADA SEL D3,
KALAU BUKAN, D3 AKAN DITULISKAN RINGAN.
RUMUS PADA D3 ADALAH...
=IF(C3>=50;"RINGAN";"BERAT"
=IF(C3>="50";"BERAT";"RINGAN"
=IF(C3>=50;"BERAT";"RINGAN"
=IF(D3>=50;"BERAT";"RINGAN"
=IF(C3>50;"BERAT";"RINGAN"
5.
MULTIPLE CHOICE QUESTION
5 sec • 1 pt
Pencarian data menggunakan lookup bilamana TIDAK memiliki tabel referensi ?
BETUL
SALAH
6.
MULTIPLE CHOICE QUESTION
5 sec • 1 pt
Pada sel A5 diketikkan nama TONO, dan
akan dimuncul pada sel A6 nilai dari TONO.
Dengan rumus lookup, rumus akan dituliskan di sel ?
A5
A6
7.
MULTIPLE CHOICE QUESTION
5 sec • 1 pt
Rumus Nama pada sel I3 adalah...
=VLOOKUP(I2;$B$2:$F$7;3;0)
=HLOOKUP(I2;$B$2:$F$7;3;0)
=VLOOKUP(I2;$A$2:$F$7;4;0)
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
Popular Resources on Wayground
7 questions
History of Valentine's Day
Interactive video
•
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
22 questions
fractions
Quiz
•
3rd Grade
15 questions
Valentine's Day Trivia
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
Discover more resources for Information Technology (IT)
10 questions
Exploring Valentine's Day with Charlie Brown
Interactive video
•
6th - 10th Grade
18 questions
Valentines Day Trivia
Quiz
•
3rd Grade - University
14 questions
Volume of rectangular prisms
Quiz
•
7th Grade
10 questions
Valentine's Day History and Traditions
Interactive video
•
6th - 10th Grade
11 questions
Valentines Day
Quiz
•
6th - 8th Grade
20 questions
Graphing Inequalities on a Number Line
Quiz
•
6th - 9th Grade
25 questions
7th Reading STAAR Vocabulary
Quiz
•
6th - 8th Grade
20 questions
Revising & Editing practice
Quiz
•
7th Grade