Vlookup dan Hlookup
8th Grade
•10 Qs
Similar activities
Quiz Jaringan Komputer dan Internet Kelas 8
8th Grade
•11 Qs
UH 2 INFORMATIKA 8
8th Grade
•15 Qs
INFORMATIKA KELAS 7A DAN TB
7th Grade - University
•15 Qs
Kegiatan Ramadhan dan Kesehatan
4th Grade - University
•15 Qs
Ulangan Harian 1 (83)
8th Grade
•10 Qs
Pretest Struktur Data Graph
8th Grade
•10 Qs
ASAS GANJIL INFORM VIII 2425
8th Grade
•12 Qs
Struktur Data
8th Grade
•10 Qs
Vlookup dan Hlookup
Quiz
•
Information Technology (IT)
•
8th Grade
•
Practice Problem
•
Hard
JAJANG HUMAEDI
Used 24+ times
FREE Resource
Enhance your content in a minute
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
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
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
Similar Resources on Wayground
10 questions
DSI Cyberbullying
Quiz
•
8th Grade
10 questions
Pemahaman Kitab-Kitab Allah
Quiz
•
8th Grade
15 questions
Tinkercad CodeBlocks
Quiz
•
1st Grade - University
10 questions
konversi bilangan
Quiz
•
8th Grade
10 questions
KUIS BAB 3
Quiz
•
7th Grade - University
10 questions
SISTEM KOMPUTER
Quiz
•
8th Grade
12 questions
Ulangan Harian Bekerja dengan Data Terstruktur
Quiz
•
8th Grade
15 questions
Ekskul Komputer - Pengetahuan Umum Komputer
Quiz
•
6th - 8th Grade
Popular Resources on Wayground
10 questions
Honoring the Significance of Veterans Day
Interactive video
•
6th - 10th Grade
9 questions
FOREST Community of Caring
Lesson
•
1st - 5th Grade
10 questions
Exploring Veterans Day: Facts and Celebrations for Kids
Interactive video
•
6th - 10th Grade
19 questions
Veterans Day
Quiz
•
5th Grade
14 questions
General Technology Use Quiz
Quiz
•
8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
Circuits, Light Energy, and Forces
Quiz
•
5th Grade
19 questions
Thanksgiving Trivia
Quiz
•
6th Grade
Discover more resources for Information Technology (IT)
10 questions
Honoring the Significance of Veterans Day
Interactive video
•
6th - 10th Grade
10 questions
Exploring Veterans Day: Facts and Celebrations for Kids
Interactive video
•
6th - 10th Grade
14 questions
General Technology Use Quiz
Quiz
•
8th Grade
15 questions
scatter plots and trend lines
Quiz
•
8th Grade
20 questions
Physical and Chemical Changes
Quiz
•
8th Grade
6 questions
Veterans Day
Lesson
•
8th Grade
13 questions
Finding slope from graph
Quiz
•
8th Grade
10 questions
Exploring Europe: Geography, History, and Culture
Interactive video
•
5th - 8th Grade