INFORMATIKA Kelas 8 semester 2 LATIHAN 2
Authored by Marjono Marjono
Computers
7th Grade
Used 20+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
8 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Pencarian data dengan fungsi lookup dimana dipakai jika range data disusun secara vertikal, menggunakan fungsi ....
Vlookup
Hlookup
reference
match
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Pencarian data dengan fungsi lookup dimana dipakai jika range data disusun secara horizontal, menggunakan fungsi ....
Vlookup
Hlookup
reference
match
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Berikut merupakn fungsi reference, kecuali ...
match
index
choose
range
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Mengembalikan posisi dari suatu nilai di dalam suatu range tabel satu dimensi. Posisi mulai dari 1, yaitu menggunakan fungsi ....
Match
Index
Choose
Range
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Mengembalikan nilai dari suatu range dua dimensi, pada alamat sel (posisi baris dan kolom) yang ditunjuk, menggunakan fungsi ....
Match
Index
Choose
Range
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Mengembalikan suatu nilai dari sederet nilai, berdasarkan nomor posisi dalam deretan nilai, menggunakan fungsi ....
Match
Index
Choose
Range
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Penulisan rumus/formula menggunakan Vlookup yang benar adalah ....
=VLOOKUP(lookup_value,table_array, col_index_num, [range_lookup])
=VLOOKUP(lookup_value,table_array, col_index_num, [range_lookup])
=VLOOKUP(lookup_value,col_index_num, table_array, [range_lookup])
=HLOOKUP(lookup_value,table_array, col_index_num, [range_lookup])
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?
