Pretest Informatika
Authored by Eka Afiyah
Information Technology (IT)
10th 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
30 sec • 10 pts
Fungsi utama dari VLOOKUP pada Excel adalah untuk…
Menjumlahkan data secara vertikal
Mencari data berdasarkan baris secara horizontal
Mencari nilai pada kolom tertentu berdasarkan nilai referensi
Menyalin data dari sheet lain
2.
MULTIPLE CHOICE QUESTION
30 sec • 10 pts
Sintaks yang benar dari fungsi HLOOKUP di Excel adalah…
=HLOOKUP(data_dasar; tabel; kolom; range_lookup)
=HLOOKUP(lookup_value; table_array; row_index; [range_lookup])
=HLOOKUP(nilai; data; baris; tepat)
=LOOKUPH(lookup_value; array; index)
3.
MULTIPLE CHOICE QUESTION
30 sec • 10 pts
Perbedaan utama antara VLOOKUP dan HLOOKUP adalah…
VLOOKUP digunakan untuk pencarian baris; HLOOKUP untuk kolom
VLOOKUP mencari data secara vertikal; HLOOKUP secara horizontal
VLOOKUP hanya digunakan untuk angka, HLOOKUP untuk teks
HLOOKUP membutuhkan dua sheet, VLOOKUP hanya satu
4.
MULTIPLE CHOICE QUESTION
30 sec • 10 pts
Perhatikan rumus berikut:
=VLOOKUP("102", A2:C6, 3, FALSE)
Rumus tersebut akan mencari…
Data pada baris ke-3
Nilai kolom ke-3 berdasarkan baris yang memiliki "102" di kolom pertama
Nilai “102” di kolom ke-3
Data 102 di kolom ke-1
5.
MULTIPLE CHOICE QUESTION
30 sec • 10 pts
Jika hasil rumus VLOOKUP adalah #N/A, maka kemungkinan besar…
Format data salah ketik
Tidak ada data yang cocok
File Excel rusak
Komputer error
6.
MULTIPLE CHOICE QUESTION
30 sec • 10 pts
Fungsi HLOOKUP paling tepat digunakan ketika…
Data disusun secara vertikal
Data disusun secara acak
Data disusun dalam bentuk kolom dan baris tidak beraturan
Data disusun secara horizontal (baris)
7.
MULTIPLE CHOICE QUESTION
30 sec • 10 pts
Apa arti dari argumen FALSE pada akhir fungsi VLOOKUP atau HLOOKUP?
Mencari data secara acak
Mencari data yang hampir mirip
Mencari data yang tidak cocok
Mencari data yang persis sama
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
Pengenalan Profesi Bidang PPLG
Quiz
•
10th Grade - University
10 questions
QUIS SISTEM KOMPUTER/OS/SISTEM OPERASI
Quiz
•
10th Grade
15 questions
Excel Funksiyalari Bo'yicha Savollar
Quiz
•
10th Grade
10 questions
Quiz Assesmen Awal "Perangkat Keras"
Quiz
•
7th Grade - University
10 questions
Keamanan Berbagi File
Quiz
•
10th Grade - University
10 questions
DPK Elemen 6 Quiz
Quiz
•
10th Grade
10 questions
Asesmen "Pengelola Kata Sandi"
Quiz
•
10th Grade - University
10 questions
Creative Mind ICT Compettion for Grade 10 adn 11
Quiz
•
10th Grade
Popular Resources on Wayground
7 questions
History of Valentine's Day
Interactive video
•
4th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
15 questions
Valentine's Day Trivia
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
Discover more resources for Information Technology (IT)
10 questions
Exploring Valentine's Day with Charlie Brown
Interactive video
•
6th - 10th Grade
18 questions
Valentines Day Trivia
Quiz
•
3rd Grade - University
20 questions
-AR -ER -IR present tense
Quiz
•
10th - 12th Grade
10 questions
Valentine's Day History and Traditions
Interactive video
•
6th - 10th Grade
21 questions
Presidents Day Trivia
Quiz
•
6th - 12th Grade
10 questions
Valentine's Day: History and Modern Celebration
Interactive video
•
9th - 12th Grade
11 questions
Valentine's Day Trivia
Quiz
•
8th - 12th Grade
10 questions
Factor Quadratic Expressions with Various Coefficients
Quiz
•
9th - 12th Grade