POST TEST HLOOKUP VLOOKUP
12th Grade
•6 Qs
Similar activities
Pos Tes 2 Fungsi String dan Lookup
9th - 12th Grade
•10 Qs
Latihan 1 Kelas X
10th Grade - University
•10 Qs
Productivity Tools - MS Excel Part 2 (Analysis)
11th - 12th Grade
•5 Qs
Microsoft Excel Quiz
12th Grade
•10 Qs
quiz kelas 9
9th - 12th Grade
•11 Qs
Menu-Menu pada Microsoft Excel Kelas A
7th Grade - University
•10 Qs
Komputer Akuntansi Quiz
12th Grade
•10 Qs
kuis informatika
8th Grade - University
•10 Qs
POST TEST HLOOKUP VLOOKUP
Quiz
•
Computers
•
12th Grade
•
Hard
Rosma Lianti
Used 3+ times
FREE Resource
6 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 15 pts
Jenis fungsi lookup yang datanya tersusun secara koordinat X horizontal adalah?
VLOOKUP
HLOOKUP
COUNTIF
MATCH
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Perhatikan tabel berikut!
Untuk mengisi sel D3 (JUMLAH), rumus yang digunakan adalah?
=Vlookup(B3;$A$11:$C$13;3)
=Hlookup(B3;$A$11:$C$13;3)
=Vlookup(B3;$A$11:$C$13;2)
=Vlookup(B3;$A$11:$C$13;2)
3.
MULTIPLE CHOICE QUESTION
1 min • 20 pts
Perhatikan tabel di atas ! Jika pada baris “ISI” diisi dengan rumus =VLOOKUP(A3,$A$2:$C$5,3)
Maka apa yang akan muncul?
Rp. 1.500.000
HANI
Rp. 1.000.000
GANJAR
4.
MULTIPLE CHOICE QUESTION
30 sec • 15 pts
Bentuk umum penulisan fungsi =Vlookup( ) adalah …
=Vlookup(range tabel, kunci, kolom ke)
=Vlookup( kolom ke, kunci, range tabel)
=Vlookup(kunci, range tabel, kolom ke)
=Vlookup(kolom ke, range tabel, kunci)
5.
MULTIPLE CHOICE QUESTION
1 min • 15 pts
Perhatikan tabel di samping!
Untuk mengisi sel C3 (NAMA BARANG), rumus yang digunakan adalah?
=Hlookup(B3;$A$11:$C$13;2)
=Vlookup(B3;$A$11:$C$13;1)
=Vlookup(B3;$A$11:$C$13;3)
=Vlookup(B3;$A$11:$C$13;2)
6.
MULTIPLE CHOICE QUESTION
1 min • 20 pts
Perhatikan tabel di atas ! Jika pada baris “ISI” diisi dengan rumus =VLOOKUP(A2;$A$2:$C2;2)
Maka apa yang akan muncul?
Rp. 1.000.000
GANJAR
Rp. 1.500.000
HANI
Similar Resources on Wayground
9 questions
ulangan kelas 2 tkj
Quiz
•
9th - 12th Grade
10 questions
PERTEMUAN 1
Quiz
•
9th - 12th Grade
10 questions
REVIEW AD KLS 9
Quiz
•
9th Grade - University
10 questions
Excel
Quiz
•
1st - 12th Grade
8 questions
untitled
Quiz
•
8th Grade - University
11 questions
CỦNG CỐ. Chủ đề 1 - Tin học 7
Quiz
•
12th Grade
10 questions
Microsoft Excel
Quiz
•
12th Grade
10 questions
latihan 3
Quiz
•
12th Grade
Popular Resources on Wayground
10 questions
Video Games
Quiz
•
6th - 12th Grade
20 questions
Brand Labels
Quiz
•
5th - 12th Grade
15 questions
Core 4 of Customer Service - Student Edition
Quiz
•
6th - 8th Grade
15 questions
What is Bullying?- Bullying Lesson Series 6-12
Lesson
•
11th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
Subtracting Integers
Quiz
•
7th Grade
22 questions
Adding Integers
Quiz
•
6th Grade
10 questions
Exploring Digital Citizenship Essentials
Interactive video
•
6th - 10th Grade