Spread Sheet Genap
10th Grade
•29 Qs
Similar activities
Kewargaan Digital
10th Grade
•25 Qs
simulasi digital PART 2
10th - 12th Grade
•27 Qs
TIK - Informatika Kelas X
10th Grade - University
•25 Qs
PTS INFORMATIKA GENAP KELAS 8
1st - 12th Grade
•25 Qs
STS 2 TIK KELAS 4 TAHUN 2024 - 2025
4th Grade - University
•25 Qs
Bazy danych
KG - University
•28 Qs
Soal Quis kelas 7
9th - 12th Grade
•25 Qs
SUMATIF ANALISIS DATA
7th Grade - University
•25 Qs
Spread Sheet Genap
Quiz
•
Computers
•
10th Grade
•
Practice Problem
•
Hard
Indra Priyadi
Used 97+ times
FREE Resource
Enhance your content in a minute
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
Data Science - Pre Assessment - Fall 2021
Quiz
•
9th - 11th Grade
25 questions
Test Operatii Word+Formule Word
Quiz
•
1st - 10th Grade
25 questions
Network Addressing & Services
Quiz
•
10th - 12th Grade
25 questions
Intro to Databases
Quiz
•
9th - 10th Grade
24 questions
CS-10 Chapter-8 DBMS Part 3: Rabin Ghimire
Quiz
•
10th Grade
25 questions
QUIZ EXCEL
Quiz
•
1st Grade - University
25 questions
Quiz Literasi Digital kelas x
Quiz
•
10th Grade
25 questions
SOAL INFORMATIKA KELAS X
Quiz
•
10th 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