IF DAN LOOKUP
7th Grade
•10 Qs
Similar activities
Pengenalan perangkat lunak pengolah angka
7th Grade
•10 Qs
Pengenalan Data dan Microsoft Excel
7th Grade
•15 Qs
Mengenal Software Pengolah Data ( Asesmen Awal Kelas 7)
7th Grade
•5 Qs
Kuis TIK_Fungsi Statistik
7th Grade
•11 Qs
Mengenal Tampilan Microsoft Excel
7th Grade
•15 Qs
CỦNG CỐ KIẾN THỨC
7th Grade
•10 Qs
Latihan PSAT
7th Grade
•11 Qs
Kuis Bebras
6th - 8th Grade
•10 Qs
IF DAN LOOKUP
Quiz
•
Information Technology (IT)
•
7th Grade
•
Practice Problem
•
Medium
TIK Talenta
Used 12+ times
FREE Resource
Enhance your content in a minute
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
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
Discover more resources for Information Technology (IT)
22 questions
distributive property
Quiz
•
7th Grade
18 questions
Angle Relationships
Quiz
•
7th Grade
10 questions
Understanding Poetry and Literary Devices
Interactive video
•
4th - 8th Grade
20 questions
How Some Friendships Last — and Others Don’t Video Questions
Quiz
•
7th Grade
18 questions
Handbook Refresher Quiz
Quiz
•
7th Grade
10 questions
Understanding Meiosis
Interactive video
•
6th - 10th Grade
20 questions
Graphing Inequalities on a Number Line
Quiz
•
6th - 9th Grade
15 questions
Making Inferences
Quiz
•
7th - 12th Grade