Q382-Formatif
8th Grade
•10 Qs
Similar activities
Pencarian Data
8th Grade
•10 Qs
Q8-PJJ2
8th Grade
•10 Qs
Latihan soal SAT 2024
8th Grade
•11 Qs
ULANGAN HARIAN INFORMATIKA KELAS 8 SMTR 1 TA. 2024/2025
8th Grade
•10 Qs
Kuis VLOOKUP
8th Grade
•10 Qs
Quiz Analisis Data Kls 8 Sem 2
8th Grade
•10 Qs
ANALISA DATA KELAS 8D 2024
8th Grade
•10 Qs
Review rumus excel Kelas 8
8th Grade
•10 Qs
Q382-Formatif
Quiz
•
Computers
•
8th Grade
•
Hard
made suardana
FREE Resource
10 questions
Show all answers
1.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
Fungsi yang digunakan untuk mendapatkan/mencari data dari sekumpulan data adalah
Lookup
Sumifs
Average
Max
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Jika range data yang akan dicari disusun secara vertikal, maka fungsi yang digunakan adalah
Lookup
Vlookup
Hlookup
Match
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Jika range data yang akan dicari disusun secara horisontal, maka fungsi yang digunakan adalah
Lookup
Vlookup
Hlookup
Match
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Berikut penulisan fungsi 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(Table_Array;Lookup_value;Col_index_num;[range_lookup])
=Vlookup(Lookup_value;Col_index_num;Lookup_value)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Berikut penulisan fungsi Hlookup yang benar adalah
=Hlookup(Lookup_value,Table_Array,raw_index_num,[range_lookup])
=Hlookup(Lookup_value.Table_Array.raw_index_num.[range_lookup])
=Hlookup(Table_Array;Lookup_value;raw_index_num;[range_lookup])
=Hlookup(Lookup_value;raw_index_num;Lookup_value)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
A2:H8
B2;H8
A2;H8
B2:H8
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
B3:B8
K4
K5
K6
Create a free account and access millions of resources
Similar Resources on Wayground
10 questions
Informatika Excel Lookup
Quiz
•
8th Grade
8 questions
Fungsi Pencarian Data di Excel
Quiz
•
8th Grade
10 questions
Data validation and verification
Quiz
•
7th - 11th Grade
5 questions
INFORMATIKA K8-2
Quiz
•
8th Grade
8 questions
Quiz tentang Fungsi IF Excel
Quiz
•
8th Grade
6 questions
INFORMATIKA K8
Quiz
•
8th Grade
10 questions
Soal informatika 8
Quiz
•
8th Grade
6 questions
Vlookup
Quiz
•
8th Grade
Popular Resources on Wayground
20 questions
Brand Labels
Quiz
•
5th - 12th Grade
10 questions
Ice Breaker Trivia: Food from Around the World
Quiz
•
3rd - 12th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
20 questions
ELA Advisory Review
Quiz
•
7th Grade
15 questions
Subtracting Integers
Quiz
•
7th Grade
22 questions
Adding Integers
Quiz
•
6th Grade
10 questions
Multiplication and Division Unknowns
Quiz
•
3rd Grade
10 questions
Exploring Digital Citizenship Essentials
Interactive video
•
6th - 10th Grade
