
POST-TEST (X-8)

Quiz
•
Computers
•
10th Grade
•
Hard
Peserta 06468
Used 1+ times
FREE Resource
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
10 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
10 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
10 sec • 1 pt
Anda memiliki data produk dan harganya dalam kolom. Untuk menampilkan harga saat pengguna memilih nama produk, Anda menggunakan…
Grafik
=VLOOKUP(...)
=COUNTIF(...)
=HLOOKUP(...)
4.
MULTIPLE CHOICE QUESTION
10 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
10 sec • 1 pt
Dalam laporan keuangan, Anda menggunakan =HLOOKUP("Total", A1:F3, 3, TRUE), namun hasilnya salah. Solusi terbaik adalah…
Ubah “TRUE” menjadi “FALSE”
Ganti fungsi menjadi SUM
Ubah baris ketiga menjadi teks
Hapus kolom pertama
6.
MULTIPLE CHOICE QUESTION
10 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
10 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
Similar Resources on Wayground
15 questions
REMEDIAL INFORMATIKA XI

Quiz
•
11th Grade
15 questions
Assesmen TIK

Quiz
•
9th - 12th Grade
6 questions
POST TEST HLOOKUP VLOOKUP

Quiz
•
12th Grade
10 questions
Fungsi HLOOKUP dan VLOOKUP

Quiz
•
12th Grade
10 questions
KT8_DM1902

Quiz
•
12th Grade
15 questions
Let's Play Excel Excel...!

Quiz
•
University
10 questions
REMEDIAL SIMDIG - US TP. 2023/2024

Quiz
•
12th Grade
10 questions
Kuis_ Informatika_SMA KELAS X

Quiz
•
9th - 12th Grade
Popular Resources on Wayground
10 questions
Video Games

Quiz
•
6th - 12th Grade
20 questions
Brand Labels

Quiz
•
5th - 12th Grade
15 questions
Core 4 of Customer Service - Student Edition

Quiz
•
6th - 8th Grade
15 questions
What is Bullying?- Bullying Lesson Series 6-12

Lesson
•
11th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
22 questions
Adding Integers

Quiz
•
6th Grade
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade
Discover more resources for Computers
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade
10 questions
Proper Keyboarding Techniques

Interactive video
•
6th - 10th Grade
10 questions
Understanding Computers: Hardware, Software, and Operating Systems

Interactive video
•
7th - 12th Grade
29 questions
AP CSP Unit 2 Review (Code.org)

Quiz
•
10th - 12th Grade