spread sheet kelas x
Authored by bayu handono
Computers
1st Grade
Used 18+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
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
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
21 questions
Quiz tentang Integrasi Excel dan Word
Quiz
•
1st Grade
22 questions
Latihan Analisis & Estimasi Biaya
Quiz
•
1st - 3rd Grade
25 questions
Computer Exam
Quiz
•
1st - 5th Grade
24 questions
Quiz Rank 1#
Quiz
•
1st Grade
20 questions
Klasy 1 LO
Quiz
•
1st Grade
20 questions
SOAL LATIHAN MICROSOFT EXCEL
Quiz
•
1st Grade
20 questions
EVALUASI SIKOMDIG TENGAH SEMESTER GENAP KLS X
Quiz
•
1st - 10th Grade
20 questions
FINAL CERDAS CERMAT KOMPUTASI 2024
Quiz
•
1st - 5th 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
12 questions
Presidents' Day
Quiz
•
KG - 5th Grade
20 questions
Telling Time to the Hour and Half hour
Quiz
•
1st Grade
10 questions
Exploring Rosa Parks and Black History Month
Interactive video
•
1st - 5th Grade
6 questions
President's Day
Lesson
•
1st Grade
10 questions
Identifying Physical and Chemical Changes
Interactive video
•
1st - 5th Grade
7 questions
Lunar and Chinese New Year for Kids | Bedtime History
Interactive video
•
1st - 12th Grade
10 questions
Presidents Day
Interactive video
•
1st - 5th Grade
15 questions
Making Inferences
Quiz
•
1st - 3rd Grade