Vlookup dan Hlookup
8th Grade
•10 Qs
Similar activities
KELAS 8
8th Grade
•10 Qs
Microbit 2
8th Grade
•15 Qs
ASAS GENAP INFORMATIKA 8
8th Grade
•12 Qs
ASESMEN AWAL KOGNITIF IFK
8th Grade
•11 Qs
Quiz Informatika Bab 1 dan 2
6th - 8th Grade
•10 Qs
ASESMEN SUMATIF
8th Grade
•10 Qs
Quiz Informatika 8
8th Grade
•10 Qs
Robotik Kodlama-Temel Bilgisayar Bilgisi
6th - 8th Grade
•15 Qs
Vlookup dan Hlookup
Quiz
•
Information Technology (IT)
•
8th Grade
•
Hard
JAJANG HUMAEDI
Used 19+ times
FREE Resource
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Vlookup dipakai jika range data atau tabel disusun secara ...
Vertikal
Horizontal
Diagonal
Miring
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Hlookup dipakai jika range data atau tabel disusun secara ...
Vertikal
Horizontal
Diagonal
Miring
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Perhatikan rumus Vlookup di bawah ini!
=vlookup(lookup_value;table_array;col_index_num;0)
Berdasarkan rumus di atas, pengertian dari lookup_value adalah ...
Nilai yang akan dicari di dalam tabel
tabel yang berisi data yang dicari
nomor kolom yang akan diambil datanya
Semua Jawaban Benar
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Perhatikan rumus Vlookup di bawah ini!
=vlookup(lookup_value;table_array;col_index_num;0)
Berdasarkan rumus di atas, pengertian dari table_array adalah ...
Nilai yang akan dicari di dalam tabel
tabel yang berisi data yang dicari
nomor kolom yang akan diambil datanya
Semua Jawaban Benar
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Perhatikan rumus Vlookup di bawah ini!
=vlookup(lookup_value;table_array;col_index_num;0)
Berdasarkan rumus di atas, pengertian dari col_index_num adalah ...
Nilai yang akan dicari di dalam tabel
tabel yang berisi data yang dicari
nomor kolom yang akan diambil datanya
Semua Jawaban Benar
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Perhatikan rumus Hlookup di bawah ini!
=hlookup(lookup_value;table_array;row_index_num;0)
Berdasarkan rumus di atas, pengertian dari row_index_num adalah ...
Nilai yang akan dicari di dalam tabel
nomor baris yang akan diambil datanya
nomor kolom yang akan diambil datanya
Semua Jawaban Benar
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Perhatikan gambar di samping ini!
Berdasarkan gambar di samping, lookup_value pada rumus tersebut adalah ...
Cell E6
Cell E7
Cell E8
Cell E9
Create a free account and access millions of resources
Similar Resources on Wayground
5 questions
Evaluasi Fungsi Pada Spreadsheet
Quiz
•
8th Grade
5 questions
STS Informatika kls 8
Quiz
•
8th Grade
15 questions
Tinkercad CodeBlocks
Quiz
•
1st Grade - University
15 questions
Refleksi Inf Kelas 8
Quiz
•
8th Grade
8 questions
Quiz di conoscenza digitale
Quiz
•
8th Grade
12 questions
Uji Pemahaman Microsoft Excel
Quiz
•
8th Grade
15 questions
Sumatif Tengah Semester Ganjil
Quiz
•
8th Grade
12 questions
Ulangan Harian Bekerja dengan Data Terstruktur
Quiz
•
8th Grade
Popular Resources on Wayground
20 questions
Brand Labels
Quiz
•
5th - 12th Grade
10 questions
Ice Breaker Trivia: Food from Around the World
Quiz
•
3rd - 12th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
20 questions
ELA Advisory Review
Quiz
•
7th Grade
15 questions
Subtracting Integers
Quiz
•
7th Grade
22 questions
Adding Integers
Quiz
•
6th Grade
10 questions
Multiplication and Division Unknowns
Quiz
•
3rd Grade
10 questions
Exploring Digital Citizenship Essentials
Interactive video
•
6th - 10th Grade
Discover more resources for Information Technology (IT)
20 questions
Brand Labels
Quiz
•
5th - 12th Grade
10 questions
Ice Breaker Trivia: Food from Around the World
Quiz
•
3rd - 12th Grade
10 questions
Exploring Digital Citizenship Essentials
Interactive video
•
6th - 10th Grade
20 questions
Figurative Language Review
Quiz
•
8th Grade
4 questions
End-of-month reflection
Quiz
•
6th - 8th Grade
20 questions
Distribute and Combine Like Terms
Quiz
•
7th - 9th Grade
20 questions
Physical and Chemical Changes
Quiz
•
8th Grade
22 questions
Newton's Laws of Motion
Lesson
•
8th Grade