spread sheet kelas x
1st Grade
•25 Qs
Similar activities
ULANGAN HARIAN INFORMATIKA
1st Grade
•20 Qs
Review Microsoft PowerPoint
1st - 5th Grade
•20 Qs
kuis data part 1
1st Grade
•20 Qs
fungsi dan formula excel
1st Grade
•20 Qs
TLJ - PTS
KG - 11th Grade
•20 Qs
Mentoring1 CompTia Network+
1st - 10th Grade
•20 Qs
Ulangan Kelas 10_Puisi
KG - 1st Grade
•20 Qs
EXCEL
1st Grade
•20 Qs
spread sheet kelas x
Quiz
•
Computers
•
1st Grade
•
Practice Problem
•
Hard
bayu handono
Used 18+ times
FREE Resource
Enhance your content in a minute
25 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
Already have an account?
Similar Resources on Wayground
25 questions
UAS Jarkom F
Quiz
•
KG - University
28 questions
Hardware & Software
Quiz
•
1st Grade
20 questions
Gerbang Logika: AND, OR, NOT
Quiz
•
1st Grade
20 questions
Access
Quiz
•
1st Grade
20 questions
ULANGAN HARIAN PBO
Quiz
•
1st - 3rd Grade
20 questions
Junior Web Developer
Quiz
•
1st Grade
20 questions
Uji Coba Tes Kelulusan Ms. Word
Quiz
•
1st - 5th Grade
25 questions
Quiz Etika dan Hukum Siber
Quiz
•
1st Grade - University
Popular Resources on Wayground
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
4:3 Model Multiplication of Decimals by Whole Numbers
Quiz
•
5th Grade
10 questions
The Best Christmas Pageant Ever Chapters 1 & 2
Quiz
•
4th Grade
12 questions
Unit 4 Review Day
Quiz
•
3rd Grade
20 questions
Christmas Trivia
Quiz
•
6th - 8th Grade
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade
14 questions
Christmas Trivia
Quiz
•
5th Grade
15 questions
Solving Equations with Variables on Both Sides Review
Quiz
•
8th Grade
Discover more resources for Computers
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade
16 questions
Christmas 1st grade
Quiz
•
1st Grade
10 questions
Exploring the Water Cycle
Interactive video
•
1st - 5th Grade
20 questions
Place Value
Quiz
•
KG - 3rd Grade
20 questions
Modules 4 - 6 CBA Review
Quiz
•
1st Grade
10 questions
Exploring the American Revolution
Interactive video
•
1st - 5th Grade
7 questions
Attack on Pearl Harbor for Kids | Bedtime History
Interactive video
•
1st - 12th Grade
15 questions
Addition and Subtraction Facts
Quiz
•
1st - 2nd Grade