LATIHAN SOAL ASTS GENAP INFORMATIKA 8
8th Grade
•40 Qs
Similar activities
[SMP-VII] Soal ASAS 2024 Ganjil
7th Grade - University
•40 Qs
SOAL TIK KELAS 8 Semester 2
8th Grade
•40 Qs
PAS Informatika Kelas 8
8th Grade
•40 Qs
IP Address
1st - 12th Grade
•40 Qs
FUNGSI LOOKUP
8th Grade
•35 Qs
Kelas 7 PTS Remidi Ganjil 2024 Informatika
7th Grade - University
•40 Qs
Sumatif Informatika ke 1
8th Grade
•40 Qs
GCSE Computing Quiz
7th - 11th Grade
•45 Qs
LATIHAN SOAL ASTS GENAP INFORMATIKA 8
Quiz
•
Computers
•
8th Grade
•
Practice Problem
•
Easy
Riski Lutfiani
Used 339+ times
FREE Resource
Enhance your content in a minute
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
FUNGSI LOOKUP
Quiz
•
8th Grade
35 questions
Micro:bit Final Quiz
Quiz
•
6th - 8th Grade
40 questions
1.1 Systems Architecture Keywords
Quiz
•
8th - 10th Grade
40 questions
Kelas 7 PTS Remidi Ganjil 2024 Informatika
Quiz
•
7th Grade - University
36 questions
Internet segura
Quiz
•
7th - 12th Grade
40 questions
IP Address
Quiz
•
1st - 12th Grade
35 questions
Technology Terms quiz
Quiz
•
8th Grade
43 questions
Computer Basics K. Robinson
Quiz
•
7th - 8th Grade
Popular Resources on Wayground
10 questions
Honoring the Significance of Veterans Day
Interactive video
•
6th - 10th Grade
9 questions
FOREST Community of Caring
Lesson
•
1st - 5th Grade
10 questions
Exploring Veterans Day: Facts and Celebrations for Kids
Interactive video
•
6th - 10th Grade
19 questions
Veterans Day
Quiz
•
5th Grade
14 questions
General Technology Use Quiz
Quiz
•
8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
Circuits, Light Energy, and Forces
Quiz
•
5th Grade
19 questions
Thanksgiving Trivia
Quiz
•
6th Grade