
POST-TEST
Authored by Maria Tumaris
Other
9th 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 • 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
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
11 questions
The SDGs quiz
Quiz
•
7th - 12th Grade
10 questions
Office Admin
Quiz
•
9th Grade
15 questions
Latihan Akhir Bab 2 Teks Prosedur
Quiz
•
9th Grade
10 questions
Quiz Iklan dan Promosi
Quiz
•
8th Grade - University
10 questions
Sistem Buku Besar dan Kertas Kerja Perusahaan Jasa
Quiz
•
9th - 12th Grade
11 questions
HTML/CSS
Quiz
•
9th - 12th Grade
10 questions
Pananaliksik
Quiz
•
7th - 11th Grade
11 questions
Economics: Role and Macroeconomic aims of government
Quiz
•
9th - 10th Grade
Popular Resources on Wayground
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
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
20 questions
Figurative Language Review
Quiz
•
6th Grade
Discover more resources for Other
20 questions
El Verbo IR Practice
Quiz
•
9th Grade
10 questions
Understanding Meiosis
Interactive video
•
6th - 10th Grade
20 questions
Graphing Inequalities on a Number Line
Quiz
•
6th - 9th Grade
15 questions
Main Idea and Supporting Details.
Quiz
•
4th - 11th Grade
10 questions
Theme
Quiz
•
9th Grade
12 questions
Exponential Growth and Decay
Quiz
•
9th Grade
20 questions
Exponent Rules Review
Quiz
•
8th - 9th Grade
25 questions
Complementary and Supplementary Angles
Quiz
•
7th - 10th Grade