Asesmen Diagnostik Vlookup & Hlookup
Authored by Peserta 06430
Computers
10th Grade
Used 2+ 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
5 mins • 1 pt
Apa nama makanan dengan kode M004?
Papeda
Sate Madura
Soto Betawi
2.
MULTIPLE CHOICE QUESTION
5 mins • 1 pt
Dari daerah manakah makanan Papeda?
Papua
Jawa Timur
Sumatra Barat
3.
MULTIPLE CHOICE QUESTION
5 mins • 1 pt
Berapa harga makanan Soto Betawi?
20.000
35.000
30.000
4.
MULTIPLE CHOICE QUESTION
5 mins • 5 pts
Rumus VLOOKUP mana yang benar untuk mencari Asal Daerah dari Kode Makanan M001?
=VLOOKUP("M001";$A$2:$C$6;2;0)
=VLOOKUP("M001";$A$2:$C$6;3;0)
=VLOOKUP("M001";$A$2:$C$6;4;0)
5.
MULTIPLE CHOICE QUESTION
5 mins • 5 pts
Rumus HLOOKUP mana yang benar untuk mencari Harga dari Kode Makanan M004?
=HLOOKUP("M004";$B$1:$F$5;5;0)
=HLOOKUP("M004";$B$1:$F$5;3;0)
=HLOOKUP("M004";$B$1:$F$4;5;0)
6.
MULTIPLE CHOICE QUESTION
5 mins • 10 pts
Buatlah formula tambahan untuk menghitung total harga jika membeli Rendang dan Sate Madura!
=VLOOKUP("Rendang"; $A$2:$E$6; 4; 0) + VLOOKUP("Sate Madura"; $A$2:$E$6; 4; 0)
=VLOOKUP("Rendang"; $A$2:$E$6; 4; 0) + VLOOKUP("Sate Madura"; $A$2:$E$6; 5; 0)
=VLOOKUP("Rendang"; $B$2:$E$6; 4; 0) + VLOOKUP("Sate Madura"; $B$2:$E$6; 4; 0)
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?
