Vlookup dan Hlookup
Authored by JAJANG HUMAEDI
Information Technology (IT)
8th Grade
Used 28+ 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
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
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
Quiz Google sheet inf 8 semester ganjil
Quiz
•
8th Grade
10 questions
Asesmen Diagnostik Membedakan Fakta dan Opini
Quiz
•
8th Grade
11 questions
ASESMEN AWAL KOGNITIF IFK
Quiz
•
8th Grade
10 questions
Pre Test Informatika Kelas 8
Quiz
•
8th Grade
10 questions
Quiz Assesmen Awal "Perangkat Keras"
Quiz
•
7th Grade - University
10 questions
Perangkat Lunak
Quiz
•
8th Grade
10 questions
Tes Perkembangan Revolusi Industri
Quiz
•
5th Grade - University
15 questions
Microbit 2
Quiz
•
8th Grade
Popular Resources on Wayground
8 questions
Spartan Way - Classroom Responsible
Quiz
•
9th - 12th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
14 questions
Boundaries & Healthy Relationships
Lesson
•
6th - 8th Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
3 questions
Integrity and Your Health
Lesson
•
6th - 8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
9 questions
FOREST Perception
Lesson
•
KG
20 questions
Main Idea and Details
Quiz
•
5th Grade
Discover more resources for Information Technology (IT)
14 questions
Boundaries & Healthy Relationships
Lesson
•
6th - 8th Grade
3 questions
Integrity and Your Health
Lesson
•
6th - 8th Grade
7 questions
SMS Playground Expectations Quiz
Quiz
•
6th - 8th Grade
16 questions
Mario Trivia Challenge
Quiz
•
6th - 8th Grade
14 questions
SMS Car & Bus Expectations Quiz
Quiz
•
6th - 8th Grade
20 questions
Scatter Plots and Line of Best Fit
Quiz
•
8th Grade
12 questions
8th U6 L4 - Fitting a Line to Data
Quiz
•
8th Grade
22 questions
Phases of the moon
Quiz
•
8th Grade