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?
Similar Resources on Wayground
10 questions
Basic Excel
Quiz
•
5th - 12th Grade
10 questions
Двоичная система счисления
Quiz
•
9th - 12th Grade
10 questions
Feet/Inches to Inches
Quiz
•
9th - 12th Grade
10 questions
Number System Conversions 1
Quiz
•
9th - 12th Grade
9 questions
Java For Loops
Quiz
•
9th - 12th Grade
11 questions
editing video
Quiz
•
12th Grade
10 questions
Latihan Soal Ms Word
Quiz
•
1st - 12th Grade
10 questions
Subnetting IPv4
Quiz
•
6th Grade - Professio...
Popular Resources on Wayground
8 questions
Spartan Way - Classroom Responsible
Quiz
•
9th - 12th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
14 questions
Boundaries & Healthy Relationships
Lesson
•
6th - 8th Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
3 questions
Integrity and Your Health
Lesson
•
6th - 8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
9 questions
FOREST Perception
Lesson
•
KG
20 questions
Main Idea and Details
Quiz
•
5th Grade