POST TEST HLOOKUP VLOOKUP
Authored by Rosma Lianti
Computers
12th Grade
Used 4+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
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
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
