POST-TEST (X-8)
10th Grade
•10 Qs
Similar activities
Pretest Aplikasi Pengolah Angka
10th Grade
•15 Qs
Quiz3_DivideConquer_GreedyApproach
University
•10 Qs
Ms. Exel dan Fungsi Logika IF
10th Grade - University
•15 Qs
Virtual Private Server
12th Grade
•15 Qs
Menu-Menu pada Microsoft Excel Kelas A
7th Grade - University
•10 Qs
Post Test #4 - Python Fundamental #3
University
•10 Qs
HTML Final Exam Review 2
University
•10 Qs
UH EXCEL TIK
10th Grade
•10 Qs
POST-TEST (X-8)
Quiz
•
Computers
•
10th Grade
•
Practice Problem
•
Hard
Peserta 06468
Used 1+ times
FREE Resource
Enhance your content in a minute
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
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
14 questions
Java HashMap Quiz
Quiz
•
11th Grade
14 questions
Spreadsheets - H Admin
Quiz
•
12th Grade
7 questions
Backup, Restore, and Recovery
Quiz
•
9th Grade - University
10 questions
Basis Data XI ~ Struktur Hirarki
Quiz
•
11th Grade
10 questions
SFC10393: Jenis-Jenis Data
Quiz
•
University
10 questions
Quiz 1 - Komunikasi & Teknik Pencarian Informasi
Quiz
•
10th Grade
11 questions
Basic HTML Tags I
Quiz
•
9th - 12th Grade
15 questions
Touch Typing Quiz 1
Quiz
•
9th - 12th Grade
Popular Resources on Wayground
10 questions
Honoring the Significance of Veterans Day
Interactive video
•
6th - 10th Grade
9 questions
FOREST Community of Caring
Lesson
•
1st - 5th Grade
10 questions
Exploring Veterans Day: Facts and Celebrations for Kids
Interactive video
•
6th - 10th Grade
19 questions
Veterans Day
Quiz
•
5th Grade
14 questions
General Technology Use Quiz
Quiz
•
8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
Circuits, Light Energy, and Forces
Quiz
•
5th Grade
19 questions
Thanksgiving Trivia
Quiz
•
6th Grade