
POST-TEST
Quiz
•
Other
•
9th Grade
•
Medium
Maria Tumaris
Used 3+ times
FREE Resource
Enhance your content in a minute
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Manakah bentuk sintaks yang benar dari fungsi HLOOKUP?
=HLOOKUP(lookup_value, row_index_num, table_array, [range_lookup])
=HLOOKUP(row_index_num, table_array, lookup_value, [range_lookup])
=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
=HLOOKUP(table_array, lookup_value, row_index_num)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Seorang staf ingin mengetahui gaji pegawai berdasarkan NIP yang tersusun dalam baris pertama. Fungsi terbaik yang digunakan adalah…
=VLOOKUP(...)
=HLOOKUP(...)
=MATCH(...)
=IF(...)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Anda memiliki data produk dan harganya dalam kolom. Untuk menampilkan harga saat pengguna memilih nama produk, Anda menggunakan…
Grafik
=HLOOKUP(...)
=VLOOKUP(...)
=COUNTIF(...)
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Dalam tabel A2:D10, kolom A berisi kode barang dan kolom D berisi harga. Jika sel E2 berisi kode yang ingin dicari, rumus yang tepat adalah…
=VLOOKUP(E2, A2:D10, 4, FALSE)
=HLOOKUP(E2, A2:D10, 4, FALSE)
=VLOOKUP(A2, E2:D10, 4, FALSE)
=IF(E2=A2, D2, 0)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Dalam laporan keuangan, Anda menggunakan =HLOOKUP("Total", A1:F3, 3, TRUE), namun hasilnya salah. Solusi terbaik adalah…
Ubah "TRUE" menjadi "FALSE"
Hapus kolom pertama
Ubah baris ketiga menjadi teks
Ganti fungsi menjadi SUM
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Hasil dari =VLOOKUP("Budi", A2:C10, 5, FALSE) adalah #REF!. Apa yang harus dilakukan?
Ganti "Budi" jadi angka
Tambahkan kolom ke-5 dalam range
Ubah menjadi TRUE
Ganti ke HLOOKUP
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
=HLOOKUP("Jumlah", A1:D3, 4, FALSE) menampilkan kesalahan. Diagnosa masalahnya dan pilih solusinya:
Kolom ke-4 salah
Tabel harus diputar
Baris ke-4 tidak tersedia → sesuaikan range
Fungsi salah → ganti VLOOKUP
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
10 questions
Pretes Monev Aksi nyata Pemanfaatan Google for Education
Quiz
•
5th Grade - University
15 questions
Physical and Intellectual Development of Infants Quiz
Quiz
•
9th - 12th Grade
10 questions
Grade 9 PE, Quiz#3: Sports Injury First Aid and Sports Offic
Quiz
•
9th Grade
12 questions
Middle Row Top Row Review
Quiz
•
5th Grade - University
8 questions
Supernatural Quiz
Quiz
•
5th Grade - Professio...
10 questions
Les moteurs de recherche
Quiz
•
1st - 12th Grade
10 questions
INFORMATIKA 9 S1 HAL 028 PA 2
Quiz
•
9th Grade
15 questions
Atletik - Lari Estafet
Quiz
•
9th Grade
Popular Resources on Wayground
10 questions
Honoring the Significance of Veterans Day
Interactive video
•
6th - 10th Grade
10 questions
Exploring Veterans Day: Facts and Celebrations for Kids
Interactive video
•
6th - 10th Grade
19 questions
Veterans Day
Quiz
•
5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
Circuits, Light Energy, and Forces
Quiz
•
5th Grade
6 questions
FOREST Self-Discipline
Lesson
•
1st - 5th Grade
7 questions
Veteran's Day
Interactive video
•
3rd Grade
20 questions
Weekly Prefix check #2
Quiz
•
4th - 7th Grade
Discover more resources for Other
10 questions
Honoring the Significance of Veterans Day
Interactive video
•
6th - 10th Grade
10 questions
Exploring Veterans Day: Facts and Celebrations for Kids
Interactive video
•
6th - 10th Grade
10 questions
Understanding Meiosis
Interactive video
•
6th - 10th Grade
10 questions
Exploring the Origins of Veterans Day
Interactive video
•
6th - 10th Grade
28 questions
Ser vs estar
Quiz
•
9th - 12th Grade
15 questions
Two Step Equations
Quiz
•
9th Grade
7 questions
Combining & Revising Sentences- EOC English I Crunchtime
Quiz
•
9th - 10th Grade
19 questions
Explore Triangle Congruence and Proofs
Quiz
•
9th - 12th Grade
