fungsi vlookup
10th Grade
•15 Qs
Similar activities
Review Komputer Mid SMA (2)
10th Grade
•10 Qs
PAS INFORMATIKA GENAP 2023
10th Grade
•20 Qs
Pretest Spreadsheet
10th Grade
•20 Qs
file ekstensi
10th - 12th Grade
•20 Qs
LOOKUP
9th Grade - University
•20 Qs
Assesmen TIK
9th - 12th Grade
•15 Qs
Latihan soal kelas 8_Analisis Data (Pencarian Data)
9th - 12th Grade
•10 Qs
Review Komputer Mid SMA (1)
10th Grade
•20 Qs
fungsi vlookup
Quiz
•
Computers
•
10th Grade
•
Hard
Komang Wijaya
Used 93+ times
FREE Resource
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi yang digunakan untuk pembacaan tabel yaitu ....
IF
MAX
MIN
Lookup
Grafik
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi yang digunakan untuk pembacaan tabel yang letaknya vertikal atau tegak lurus yaitu ....
Lookup
Hlookup
Vlookup
IF
Logika
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi yang digunakan untuk pembacaan tabel yang letaknya horizontal atau sejajar yaitu ....
Lookup
Hlookup
Vlookup
Logika
Grafik
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Bentuk umum penulisan rumus fungsi hlookup adalah ....
=HLOOKUP(criteria cell;nama_tabel;no_kolom;0)
=HLOOKUP(nama_tabel;criteria cell;no_kolom;0)
HLOOKUP(criteria cell;nama_tabel;no_kolom;0)
=HLOOKUP(criteria cell;nama_tabel;no_kolom
=VLOOKUP(criteria cell;nama_tabel;no_kolom;0)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Penulisan rumus HLOOKUP dibawah ini yang benar adalah ....
HLOOKUP(A3,G2:h5,2)
=HLOOKUP(A3,G2;h5,2)
=HLOOKUP(A3,G2:h5)
=HLOOKUP(A3,G2:h5,2)
=HLOOKUP(A3;G2:h5;2)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Tombol yang digunakan untuk mengabsolutkan sell yaitu ....
F1
F2
F3
F4
F5
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Penulisan rumus VLOOKUP dibawah ini yang benar adalah ....
VLOOKUP(A3,G2:h5,2)
=VLOOKUP(A3,G2;h5,2)
=VLOOKUP(A3,G2:h5)
=HLOOKUP(A3,G2:h5,2)
=VLOOKUP(A3;G2:h5;2)
Create a free account and access millions of resources
Similar Resources on Wayground
16 questions
SUMATIF 1 ANALISIS DATA
Quiz
•
8th Grade - University
10 questions
Quiz Fungsi Excel
Quiz
•
9th Grade - University
10 questions
Ulangan Harian Aplikasi Pengolah Informasi
Quiz
•
10th Grade
10 questions
Pos Tes 2 Fungsi String dan Lookup
Quiz
•
9th - 12th Grade
20 questions
PTS Elemen Spreadsheet
Quiz
•
10th Grade
10 questions
Hlookup
Quiz
•
10th Grade
14 questions
Ms Excel
Quiz
•
10th Grade
11 questions
Quiz Spreadsheet 2
Quiz
•
10th Grade
Popular Resources on Wayground
15 questions
Hersheys' Travels Quiz (AM)
Quiz
•
6th - 8th Grade
20 questions
PBIS-HGMS
Quiz
•
6th - 8th Grade
30 questions
Lufkin Road Middle School Student Handbook & Policies Assessment
Quiz
•
7th Grade
20 questions
Multiplication Facts
Quiz
•
3rd Grade
17 questions
MIXED Factoring Review
Quiz
•
KG - University
10 questions
Laws of Exponents
Quiz
•
9th Grade
10 questions
Characterization
Quiz
•
3rd - 7th Grade
10 questions
Multiply Fractions
Quiz
•
6th Grade