Fungsi VLOOKUP digunakan untuk mencari nilai dalam kolom tertentu berdasarkan nilai tertentu pada baris tertentu dalam rentang data.
PreTest Pencarian Data
8th Grade
•10 Qs
Similar activities
Andi Abrianto
8th Grade
•15 Qs
Quiz Analisis Data Kelas VIII Informatika
8th Grade
•15 Qs
Quiz Pengenalan Pemrograman
8th Grade
•15 Qs
Analisis Data Informatika
8th Grade
•12 Qs
Memahami prinsip kerja subscriber internet telepon (TLJ)
1st Grade - University
•15 Qs
Quiz Microsoft Excel #2
8th Grade
•14 Qs
Kuis Fungsi HLOOKUP-2
8th Grade
•10 Qs
Data Diskrit Quiz Remidi 8A
8th Grade
•11 Qs
PreTest Pencarian Data
Quiz
•
Computers
•
8th Grade
•
Hard
MOHAMMAD RIZKY NOER ALIF
Used 3+ times
FREE Resource
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
20 sec • 10 pts
Benar
Salah
2.
MULTIPLE CHOICE QUESTION
20 sec • 10 pts
Fungsi HLOOKUP digunakan untuk mencari nilai dalam baris tertentu berdasarkan nilai tertentu pada kolom tertentu dalam rentang data.
Benar
Salah
3.
MULTIPLE CHOICE QUESTION
20 sec • 10 pts
Fungsi MATCH digunakan untuk mengembalikan nilai dari sel tertentu dalam rentang data berdasarkan nomor baris dan kolom yang ditentukan.
Benar
Salah
4.
MULTIPLE CHOICE QUESTION
20 sec • 10 pts
Fungsi INDEX digunakan untuk mengembalikan posisi relatif suatu nilai dalam rentang data.
Benar
Salah
5.
MULTIPLE CHOICE QUESTION
20 sec • 10 pts
Fungsi CHOOSE dapat digunakan untuk memilih antara beberapa opsi berdasarkan nomor yang diberikan.
Benar
Salah
6.
MULTIPLE CHOICE QUESTION
20 sec • 10 pts
VLOOKUP dan HLOOKUP keduanya digunakan untuk mencari nilai dalam baris tertentu.
Benar
Salah
7.
MULTIPLE CHOICE QUESTION
20 sec • 10 pts
Fungsi MATCH akan mengembalikan nilai 0 jika tidak menemukan nilai yang cocok dalam rentang data.
Benar
Salah
Create a free account and access millions of resources
Create resources
Host any resource
Get auto-graded reports
Microsoft
Apple
Others
Similar Resources on Quizizz
15 questions
Quiz Peringkasan Data dan Analisis
Quiz
•
8th Grade
10 questions
Aplikasi Komputer
Quiz
•
1st Grade - University
15 questions
Operator dan Kontrol Struktur PHP
Quiz
•
2nd Grade - University
15 questions
Fitur Cut, Copy, Paste, Screen Shof, dan Sniping Tools
Quiz
•
8th Grade
10 questions
Materi Lookup dan Vlookup
Quiz
•
8th Grade
10 questions
Kuis Fungsi Hlookup
Quiz
•
8th Grade
15 questions
PAS TIK Kelas VIII STL
Quiz
•
8th Grade
11 questions
EP-7-3-Analisis Data
Quiz
•
7th - 9th Grade
Popular Resources on Quizizz
15 questions
Multiplication Facts
Quiz
•
4th Grade
25 questions
SS Combined Advisory Quiz
Quiz
•
6th - 8th Grade
40 questions
Week 4 Student In Class Practice Set
Quiz
•
9th - 12th Grade
40 questions
SOL: ILE DNA Tech, Gen, Evol 2025
Quiz
•
9th - 12th Grade
20 questions
NC Universities (R2H)
Quiz
•
9th - 12th Grade
15 questions
June Review Quiz
Quiz
•
Professional Development
20 questions
Congruent and Similar Triangles
Quiz
•
8th Grade
25 questions
Triangle Inequalities
Quiz
•
10th - 12th Grade
Discover more resources for Computers
25 questions
SS Combined Advisory Quiz
Quiz
•
6th - 8th Grade
20 questions
Congruent and Similar Triangles
Quiz
•
8th Grade
14 questions
Exterior and Interior angles of Polygons
Quiz
•
8th Grade
6 questions
Earth's energy budget and the greenhouse effect
Lesson
•
6th - 8th Grade
15 questions
SMART Goals
Quiz
•
8th - 12th Grade
20 questions
Lesson: Slope and Y-intercept from a graph
Quiz
•
8th Grade