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
PRETEST ANALISIS DATA PERTEMUAN 1
8th Grade
•10 Qs
Informatika - Analisis Data
8th Grade
•10 Qs
Pencarian Data - Unit Analisis Data
8th Grade
•10 Qs
Pengantar C/C++/Java
1st - 12th Grade
•9 Qs
Asesmen Awal Pengolah Data Dasar
7th Grade - University
•10 Qs
Uji Pemahaman VLOOKUP dan HLOOKUP
8th Grade
•10 Qs
Data Analysis - Grade 8 Computers Quiz
8th Grade
•8 Qs
SUMATIF INFORMATIKA VIII
8th Grade
•10 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
PAS TIK Kelas VIII STL
Quiz
•
8th Grade
15 questions
Quiz Peringkasan Data dan Fungsi Excel BAB VI
Quiz
•
8th Grade
11 questions
EP-7-3-Analisis Data
Quiz
•
7th - 9th Grade
10 questions
Kelas 8 Latihan Soal Worksheet Bab 8-9
Quiz
•
8th Grade
10 questions
ANALISIS DATA PERTEMUAN 1
Quiz
•
8th Grade
10 questions
Kuis Fungsi HLOOKUP-2
Quiz
•
8th Grade
11 questions
Data Diskrit Quiz Remidi 8A
Quiz
•
8th Grade
15 questions
Quiz Analisis Data Kelas VIII Informatika
Quiz
•
8th 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