Vlookup dan Hlookup
8th Grade
•10 Qs
Similar activities
Kecerdasan Artifisial dalam Kehidupan Sehari-hari
6th Grade - University
•10 Qs
XI 5_UH XI INFORMATIKA
2nd Grade - University
•10 Qs
TEKNIK KOMPUTER JARINGAN
2nd Grade - University
•15 Qs
Latihan Soal Sistem Komputer
8th Grade
•10 Qs
Kuis Microsoft Word
8th Grade
•15 Qs
KUIS TIK XLS
8th Grade
•10 Qs
Fakta, Opini, Hoaks di Dunia Digital
8th Grade
•10 Qs
Kuis Bab 1_Informatika
8th Grade
•10 Qs
Vlookup dan Hlookup
Quiz
•
Information Technology (IT)
•
8th Grade
•
Practice Problem
•
Hard
JAJANG HUMAEDI
Used 27+ 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
Already have an account?
Similar Resources on Wayground
15 questions
Soal Informatika Kelas 8 BAB 3 Sistem Komputer - 01
Quiz
•
8th Grade
11 questions
Kuis Bab Berpikir Komputasional
Quiz
•
8th Grade
15 questions
PENILAIAN HARIAN-BAB 2 (BERPIKIR KOMPUTASIONAL)
Quiz
•
8th Grade
10 questions
PRETEST KODING DAN KA
Quiz
•
5th Grade - University
10 questions
Analisis Data
Quiz
•
8th Grade - University
10 questions
FUNGSI REFERENCE
Quiz
•
8th Grade - University
10 questions
informatika terseyum
Quiz
•
8th Grade
10 questions
Informatika 2
Quiz
•
7th Grade - University
Popular Resources on Wayground
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
4:3 Model Multiplication of Decimals by Whole Numbers
Quiz
•
5th Grade
10 questions
The Best Christmas Pageant Ever Chapters 1 & 2
Quiz
•
4th Grade
12 questions
Unit 4 Review Day
Quiz
•
3rd Grade
20 questions
Christmas Trivia
Quiz
•
6th - 8th Grade
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade
14 questions
Christmas Trivia
Quiz
•
5th Grade
15 questions
Solving Equations with Variables on Both Sides Review
Quiz
•
8th Grade
Discover more resources for Information Technology (IT)
20 questions
Christmas Trivia
Quiz
•
6th - 8th Grade
15 questions
Solving Equations with Variables on Both Sides Review
Quiz
•
8th Grade
15 questions
scatter plots and trend lines
Quiz
•
8th Grade
10 questions
Understanding Meiosis
Interactive video
•
6th - 10th Grade
26 questions
Christmas Movie Trivia
Lesson
•
8th Grade - Professio...
20 questions
Informational Text Structures
Quiz
•
6th - 8th Grade
20 questions
Slope from a Graph
Quiz
•
8th Grade
10 questions
Understanding Earth's Movements and Seasons
Interactive video
•
4th - 8th Grade