PreTest Pencarian Data
Authored by MOHAMMAD RIZKY NOER ALIF
Computers
8th Grade
Used 3+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
20 sec • 10 pts
Fungsi VLOOKUP digunakan untuk mencari nilai dalam kolom tertentu berdasarkan nilai tertentu pada baris tertentu dalam rentang data.
Benar
Salah
2.
MULTIPLE CHOICE QUESTION
20 sec • 10 pts
Fungsi HLOOKUP digunakan untuk mencari nilai dalam baris tertentu berdasarkan nilai tertentu pada kolom tertentu dalam rentang data.
Benar
Salah
3.
MULTIPLE CHOICE QUESTION
20 sec • 10 pts
Fungsi MATCH digunakan untuk mengembalikan nilai dari sel tertentu dalam rentang data berdasarkan nomor baris dan kolom yang ditentukan.
Benar
Salah
4.
MULTIPLE CHOICE QUESTION
20 sec • 10 pts
Fungsi INDEX digunakan untuk mengembalikan posisi relatif suatu nilai dalam rentang data.
Benar
Salah
5.
MULTIPLE CHOICE QUESTION
20 sec • 10 pts
Fungsi CHOOSE dapat digunakan untuk memilih antara beberapa opsi berdasarkan nomor yang diberikan.
Benar
Salah
6.
MULTIPLE CHOICE QUESTION
20 sec • 10 pts
VLOOKUP dan HLOOKUP keduanya digunakan untuk mencari nilai dalam baris tertentu.
Benar
Salah
7.
MULTIPLE CHOICE QUESTION
20 sec • 10 pts
Fungsi MATCH akan mengembalikan nilai 0 jika tidak menemukan nilai yang cocok dalam rentang data.
Benar
Salah
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?
Similar Resources on Wayground
10 questions
QUIZ IF KLS 8 ALGORIT DAN PRO
Quiz
•
8th Grade
13 questions
KSSM-Konsep Asas Pemikiran Komputasional (Tingkatan 1)
Quiz
•
7th - 9th Grade
12 questions
menu dan icon kls VII
Quiz
•
7th - 9th Grade
10 questions
Soal Latihan 2 - Scratch
Quiz
•
8th - 12th Grade
10 questions
Informatika
Quiz
•
6th - 8th Grade
15 questions
Netiquette (Etika Berinternet)
Quiz
•
7th Grade - University
10 questions
Analisis Data Fungsi Reference
Quiz
•
8th Grade
10 questions
ASK T1 - Kuiz Kod Arahan HTML
Quiz
•
7th - 9th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
10 questions
Probability Practice
Quiz
•
4th Grade
15 questions
Probability on Number LIne
Quiz
•
4th Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
6 questions
Appropriate Chromebook Usage
Lesson
•
7th Grade
10 questions
Greek Bases tele and phon
Quiz
•
6th - 8th Grade
