SUMATIF 1 ANALISIS DATA
8th Grade
•16 Qs
Similar activities
Bài 29. Nhận biết lỗi chương trình
9th - 12th Grade
•14 Qs
PRETEST TIK KELAS 8
8th Grade
•20 Qs
CSS Acronyms
9th - 10th Grade
•20 Qs
UH2 Ms. Excel
9th Grade
•15 Qs
JAVA - Arrays
University - Professional Development
•15 Qs
Data Structures: 1D,2D & List
11th Grade
•17 Qs
Strategi Algoritmik dan Pemrograman
11th Grade
•20 Qs
Intro to Data Mining
University
•15 Qs
SUMATIF 1 ANALISIS DATA
Quiz
•
Computers
•
8th Grade
•
Practice Problem
•
Hard
MUH. IQBAL
FREE Resource
Enhance your content in a minute
16 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Dibawah ini yang tidak termasuk rumus pencarian data pada excel adalah…
Vlookup
Hlookup
Index Match
SUM
2.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Dibawah ini yang termasuk rumus excel untuk melakukan pencarian data dalam bentuk vertikal adalah…
Hlookup
Hlokup
Vlookup
Vlokup
3.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Rumus excel yang digunakan untuk melakukan pencarian data dalam bentuk horiontal adalah…
Vlokup
Vlookup
Hlookup
Hlokup
4.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Jawaban yang paling benar dalam contoh penulisan rumus excel untuk Vlookup adalah…
=VLOOKUP(lookup_value; table_array; col_index_num;TRUE)
=VLOOKUP(lookup_value; table_array; col_index_num;FALSE)
=VLOOKUP(lookup_value; col_index_num;FALSE)
=VLOOKUP(lookup_value; table_array; ;TRUE)
5.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Jawaban yang paling tepat untuk rumus excel dalam melakukan pencarian data menggunakan HLOOKUP adalah…
=HLOOKUP(lookup_value;table_array;row_index_num;TRUE)
=HLOOKUP(lookup_value;table_array;row_index_num;FALSE)
=HLOKUP(lookup_value;table_array;row_index_num;TRUE)
HLOKUP(lookup_value;table_array;row_index_num;FALSE)
6.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Pernyataan dibawah ini yang paling benar mengenai rumus excel INDEX adalah…
Mencari posisi sel dalam baris dan kolom
Melakukan pencarian data dengan mengambil nilai sel dalam tabel berdasarkan posisi sel nya
Rumus excel untuk melakukan pengolahan data
Melakukan pencarian data yang disusun secara vertikal
7.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Pernyataan dibawah ini yang paling benar mengenai rumus excel MATCH adalah…
Mencari posisi sel dalam baris dan kolom
Melakukan pencarian data dengan mengambil nilai sel dalam tabel berdasarkan posisi sel nya
Rumus excel untuk melakukan pengolahan data
Melakukan pencarian data yang disusun secara vertikal
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
20 questions
PSTS INFORMATIKA X
Quiz
•
10th Grade - University
13 questions
Arrays in Swift
Quiz
•
10th - 12th Grade
18 questions
LATIHAN INFORMATIKA
Quiz
•
9th Grade
20 questions
QUIZ BAB 4: SISTEM OPERASI
Quiz
•
8th Grade - University
19 questions
QUIZ INFORMATIKA
Quiz
•
1st - 10th Grade
20 questions
KELAS 7 1
Quiz
•
9th - 12th Grade
20 questions
UH Informatika Bab.VI
Quiz
•
8th Grade
20 questions
Visualisasi data
Quiz
•
8th Grade - University
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