Spread Sheet Genap
Quiz
•
Computers
•
10th Grade
•
Hard
Indra Priyadi
Used 97+ times
FREE Resource
29 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi yang digunakan untuk membaca table secara vertikal yang benar adalah....
=IF
=DDB
=CREAT
=VLOOKUP
=HLOOKUP
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
"Lookup_value" pada penulisan fungsi VLOOKUP adalah untuk menyatakan....
alamat cell pembanding
range tabel array
alamat cell hasil
nomor urut dalam table
nama tabel data
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Penulisan fungsi VLOOKUP yang benar adalah....
=VLOOKUP(lookup_value;Tabel_array;Col_index_num:Range_lookup)
=VLOOKUP(lookup_value:Tabel_array,Col_index_num;Range_lookup)
=VLOOKUP(lookup_value;Tabel_array;Col_index_num;Range_lookup)
=VLOOKUP(lookup_value:Tabel_array;Col_index_num;Range_lookup)
=VLOOKUP(lookup_value;Tabel_array,Col_index_num,Range_lookup)
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Untuk menghitung jumlah data cell dalam sebuah tabel digunakan fungsi....
SUMIF
SUM
COUNT
COUNTA
COUNTIF
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Nama range tabel yang akan dibaca adalah....
lookup_value
table_array
col_index_num
row_index_num
range_lookup
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi VLOOKUP adalah fungsi untuk....
pembacaan tabel
pembacaan tabel secara horizontal
pembacaan tabel secara vertikal
pembacaan data secara acak
pembacaan tabel secara vertical maupun horizontal
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Argumen yang akan menentukan tingkat ketepatan pembacaan adalah....
lookup_value
table_array
col_index_num
row_index_num
range_lookup
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
25 questions
TIK - Informatika Kelas X
Quiz
•
10th Grade - University
25 questions
STS 2 TIK KELAS 4 TAHUN 2024 - 2025
Quiz
•
4th Grade - University
25 questions
Kuis Pertemuan Ke-10 Mulok Microsoft Word
Quiz
•
10th Grade
25 questions
Informatika
Quiz
•
10th Grade
25 questions
Asesmen Literasi Digital X.TO-A
Quiz
•
10th Grade
25 questions
R050 Data, Information and Testing
Quiz
•
10th Grade
28 questions
Bazy danych
Quiz
•
KG - University
25 questions
Kewargaan Digital
Quiz
•
10th Grade
Popular Resources on Wayground
20 questions
Halloween Trivia
Quiz
•
6th - 8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
Order of Operations
Quiz
•
5th Grade
20 questions
Halloween
Quiz
•
5th Grade
16 questions
Halloween
Quiz
•
3rd Grade
12 questions
It's The Great Pumpkin Charlie Brown
Quiz
•
1st - 5th Grade
20 questions
Possessive Nouns
Quiz
•
5th Grade
10 questions
Halloween Traditions and Origins
Interactive video
•
5th - 10th Grade
Discover more resources for Computers
10 questions
Halloween Traditions and Origins
Interactive video
•
5th - 10th Grade
20 questions
Halloween movies trivia
Quiz
•
7th - 12th Grade
15 questions
Halloween Characters
Quiz
•
7th - 12th Grade
10 questions
Halloween Movies Trivia
Quiz
•
5th Grade - University
10 questions
Halloween Trivia Challenge
Interactive video
•
6th - 10th Grade
10 questions
Understanding Meiosis
Interactive video
•
6th - 10th Grade
14 questions
Halloween Fun
Quiz
•
2nd - 12th Grade
28 questions
Ser vs estar
Quiz
•
9th - 12th Grade
