LATIHAN SOAL ASTS GENAP INFORMATIKA 8
8th Grade
•40 Qs
Similar activities
LATIHAN SOAL BK KELAS 8
8th Grade
•35 Qs
Excel
1st Grade - University
•40 Qs
ASLM Genap Analisis Data
8th Grade
•35 Qs
Latihan Soal ASAS Ganjil Informatika 8
8th Grade
•40 Qs
KUIS SUMPAH PEMUDA KELAS 8
8th Grade
•45 Qs
Bài tập Excel
6th Grade - University
•40 Qs
MYE Revision 7 & 8
7th - 8th Grade
•35 Qs
Soal PTS Kelas 8 Informatika
8th Grade
•40 Qs
LATIHAN SOAL ASTS GENAP INFORMATIKA 8
Quiz
•
Computers
•
8th Grade
•
Easy
Riski Lutfiani
Used 339+ times
FREE Resource
40 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Perhatikan data berikut!
(1) SLOOKUP
(2) HLOOKUP
(3) XLOOKUP
(4) VLOOKUP
Yang termasuk fungsi LOOKUP adalah nomor ... .
1 dan 2
1 dan 3
2 dan 4
4 saja
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Untuk mencari tinggi badan pada tabel tersebut, kita harus menggunakan fungsi ... .
HLOOKUP
LOOKUP
CLOOKUP
VLOOKUP
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Rumus untuk mencari nama customer adalah ... .
=HLOOKUP(B3;$G$2:$J$12;4;FALSE)
=VLOOKUP(B3;$G$2:$J$12;4;FALSE)
=VLOOKUP(B3;$G$2:$J$12;2;FALSE)
=HLOOKUP(B3;$G$2:$J$12;2;FALSE)
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
rumus untuk mencari tinggi badan pada tabel tersebut adalah ... .
=HLOOKUP(B3;$F$9:$K$10:2;FALSE)
=HLOOKUP(B3;$F$9:$K$10:1;FALSE)
=VLOOKUP(B3;$F$9:$K$10:2;FALSE)
=VLOOKUP(B3;$F$9:$K$10:1;FALSE)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Perbedaan HLOOKUP dan VLOOKUP yang tepat adalah ... .
ketika data disajika dalam bentuk vertical, maka bisa menggunakan fungsi HLOOKUP untuk pencarian data
HLOOKUP dapat digunakan untuk menghitung data yag disajikan dalam bentuk horizontal
ketika data disajikan dalam bentuk vertical maka bisa menggunakan fungsi VLOOKUP untuk pencarian data
VLOOKUP dapat digunakan untuk menghitung data yang disajikan dalam bentuk vertical
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Perhatikan data berikut!
(1) MATCH
(2) VLOOKUP
(3) CHOOSE
(4) INDEX
Yang termasuk fungsi REFERENCE adalah ... .
1 dan 3
1,3,4
2 dan 4
2,3,4
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi utama fungsi INDEX adalah ... .
menampilkan nilai terbesar dalam suatu range
mengurutkan data dalam tabel
menghasilkan nilai elemen pada tabel berdasarkan nomor indeks baris dan kolom
menghitung jumlah total dalam suatu range
Create a free account and access millions of resources
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
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
Similar Resources on Wayground
35 questions
Scratch coding
Quiz
•
7th - 9th Grade
44 questions
MICROSOFT OFFICE ICON
Quiz
•
KG - 12th Grade
42 questions
Input, Output, Processing, & Storage
Quiz
•
6th - 8th Grade
45 questions
UTS INFORMATIKA KELAS 8
Quiz
•
8th Grade
40 questions
SOAL UJIAN TIK
Quiz
•
8th Grade
38 questions
Chủ đề 1: CĂN BẢN VỀ CÔNG NGHỆ (GS6 Spark LV2_2024)
Quiz
•
1st Grade - University
44 questions
Parts of a Computer
Quiz
•
5th - 8th Grade
40 questions
ASAS SAINS KOMPUTER T2 [ULANGKAJI]
Quiz
•
1st Grade - University
Popular Resources on Wayground
20 questions
Halloween Trivia
Quiz
•
6th - 8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
Order of Operations
Quiz
•
5th Grade
20 questions
Halloween
Quiz
•
5th Grade
16 questions
Halloween
Quiz
•
3rd Grade
12 questions
It's The Great Pumpkin Charlie Brown
Quiz
•
1st - 5th Grade
20 questions
Possessive Nouns
Quiz
•
5th Grade
10 questions
Halloween Traditions and Origins
Interactive video
•
5th - 10th Grade