
PRE-TEST (X-5)
Authored by Lita Zahra
Computers
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 • 1 pt
Fungsi utama dari rumus VLOOKUP di Excel adalah.....
Menjumlahkan data vertikal
Mencari data dalam tabel secara vertikal
Menghapus data duplikat
Menyortir data berdasarkan kolom
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Sintaks dasar dari fungsi HLOOKUP adalah....
=HLOOKUP(nilai_cari; tabel; indeks_kolom; [range_lookup])
=HLOOKUP(nilai_cari; tabel; indeks_baris; [range_lookup])
=HLOOKUP(tabel; nilai_cari; indeks_baris; [range_lookup])
=HLOOKUP(nilai_cari; indeks_kolom; tabel; [range_lookup])
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Perbedaan utama antara VLOOKUP dan HLOOKUP?
VLOOKUP untuk angka, HLOOKUP untuk teks
VLOOKUP mencari secara horizontal, HLOOKUP secara vertikal
VLOOKUP mencari secara vertikal, HLOOKUP secara horizontal
Tidak ada perbedaan
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Dalam kehidupan sehari-hari, fungsi VLOOKUP dapat digunakan untuk...
Menarik grafik batang
Mengubah format tanggal
Menghitung luas lingkaran
Mencari harga barang dalam tabel daftar belanja
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Jika rumus VLOOKUP mengembalikan kesalahan #N/A, kemungkinan penyebabnya adalah...
Nilai yang dicari tidak ada di kolom pertama tabel
Excel tidak berfungsi
Tabel terlalu panjang
Data tidak disimpan
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Dalam VLOOKUP, apa arti FALSE di akhir rumus?
Hitung jumlah kolom
Mencari data mendekati
Mencari data yang tepat
Tidak ada arti
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Apa yang akan terjadi jika kita menggunakan VLOOKUP tanpa menulis FALSE?
Excel akan mencocokkan data yang mendekati
Excel akan berhenti bekerja
Excel akan mencocokkan data yang tepat
Excel akan menghapus data
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
15 questions
quiz Pertama XII
Quiz
•
9th - 12th Grade
15 questions
Sejarah Komputer 2
Quiz
•
1st - 12th Grade
11 questions
Types of Mass Media
Quiz
•
10th Grade - Professi...
11 questions
Programming basics
Quiz
•
10th - 11th Grade
10 questions
Sistem Optic
Quiz
•
10th Grade
12 questions
OCR Internet Technologies
Quiz
•
10th - 11th Grade
15 questions
MIT APP - QUIZ
Quiz
•
10th Grade
15 questions
Computer Software Quiz
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 Computers
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