Fungsi VLOOKUP digunakan untuk mencari data dalam tabel yang disusun secara (a)

Latihan Informatika VLOOKUP RUANGPUBLIK

Quiz
•
Computers
•
8th Grade
•
Medium
Ni Mustikawati
Used 7+ times
FREE Resource
25 questions
Show all answers
1.
DRAG AND DROP QUESTION
30 sec • 4 pts
2.
MULTIPLE CHOICE QUESTION
30 sec • 4 pts
Dalam rumus =VLOOKUP(lookup_value, table_array, col_index_num), bagian yang menunjukkan tabel tempat pencarian data disebut...
table_array
lookup_value
col_index_num
row_index_num
3.
MULTIPLE CHOICE QUESTION
30 sec • 4 pts
Jika tabel data disusun dalam format mendatar ke samping, fungsi yang digunakan adalah...
HLOOKUP
FIND
VLOOKUP
LOOKUP
4.
MULTIPLE CHOICE QUESTION
30 sec • 4 pts
Dalam fungsi HLOOKUP, row_index_num menunjukkan...
Nomor baris tempat data berada
Nomor kolom tempat data berada
Lokasi tabel dalam spreadsheet
Nilai yang dicari dalam tabel
5.
MULTIPLE CHOICE QUESTION
30 sec • 4 pts
Apa yang akan terjadi jika data yang dicari dengan VLOOKUP tidak ditemukan dalam tabel?
Hasilnya adalah "0"
Akan menampilkan data dari kolom pertama
Spreadheet akan menampilkan pesan kesalahan
Proses pencarian otomatis mencari di tabel lain
6.
DRAG AND DROP QUESTION
30 sec • 4 pts
Pada penggunaan fungsi VLOOKUP, kolom pertama dari tabel data harus berisi (a) .
7.
DROPDOWN QUESTION
30 sec • 4 pts
Jika kita ingin mencari data dalam tabel yang berisi banyak kolom dan ingin mengembalikan nilai dari kolom ke-5, maka dalam rumus VLOOKUP, kita harus menggunakan (a) sebagai col_index_num.
Create a free account and access millions of resources
Similar Resources on Quizizz
20 questions
Fungsi VLOOKUP dan HLOOKUP

Quiz
•
8th Grade
25 questions
STS Genap Informatika 8

Quiz
•
8th Grade
20 questions
LATIHAN SOAL INFORMATIKA

Quiz
•
8th Grade
25 questions
Sumatif Analisis Data

Quiz
•
8th Grade
20 questions
ulangan informatika

Quiz
•
8th Grade
25 questions
ATS GENAP 2025 INFORMATIKA 8

Quiz
•
8th Grade
20 questions
Latihan Soal Fungsi Logika Di Ms. Excel

Quiz
•
8th Grade
20 questions
Ulangan Informatika - Analisis Data

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