Dibawah ini yang tidak termasuk rumus pencarian data pada excel adalah…
Pencarian data dan chart
8th Grade
•15 Qs
Similar activities
Pencarian Data dengan Fungsi Lookup
8th Grade
•20 Qs
Quiz Informatika Kelas VIII
8th Grade - University
•20 Qs
Latihan
8th Grade
•15 Qs
UH Informatika Bab.VI
8th Grade
•20 Qs
SUMATIF 1 ANALISIS DATA
8th Grade - University
•16 Qs
Ulangan Harian 1
8th Grade
•10 Qs
Latihan PAT Informatika Kelas 8
8th Grade
•20 Qs
AD-dengan fungsi reference
8th Grade
•20 Qs
Pencarian data dan chart
Quiz
•
Computers
•
8th Grade
•
Hard
AINUL MARDHIAH
Used 5+ times
FREE Resource
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
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
Microsoft
Apple
Others
Similar Resources on Quizizz
10 questions
FUNGSI LOOKUP
Quiz
•
8th Grade
10 questions
ULANGAN HARIAN INFORMATIKA KELAS 8 SMTR 1 TA. 2024/2025
Quiz
•
8th Grade
20 questions
Latihan PAT Informatika Kelas 8
Quiz
•
8th Grade
11 questions
Latihan soal SAT 2024
Quiz
•
8th Grade
20 questions
Quiz PTS Informatika 8
Quiz
•
8th Grade
20 questions
Analisa data sem2
Quiz
•
8th Grade
11 questions
Quiz 5: Internet safety, cyber security and encryption
Quiz
•
7th - 8th Grade
10 questions
Ulangan Harian Bab 6
Quiz
•
8th Grade
Popular Resources on Quizizz
15 questions
Multiplication Facts
Quiz
•
4th Grade
20 questions
Math Review - Grade 6
Quiz
•
6th Grade
20 questions
math review
Quiz
•
4th Grade
5 questions
capitalization in sentences
Quiz
•
5th - 8th Grade
10 questions
Juneteenth History and Significance
Interactive video
•
5th - 8th Grade
15 questions
Adding and Subtracting Fractions
Quiz
•
5th Grade
10 questions
R2H Day One Internship Expectation Review Guidelines
Quiz
•
Professional Development
12 questions
Dividing Fractions
Quiz
•
6th Grade
Discover more resources for Computers
5 questions
capitalization in sentences
Quiz
•
5th - 8th Grade
10 questions
Juneteenth History and Significance
Interactive video
•
5th - 8th Grade
10 questions
Identify Slope and y-intercept (from equation)
Quiz
•
8th - 9th Grade
10 questions
Juneteenth: History and Significance
Interactive video
•
7th - 12th Grade
15 questions
Volume Prisms, Cylinders, Cones & Spheres
Quiz
•
8th Grade
26 questions
June 19th
Quiz
•
4th - 9th Grade
25 questions
Argumentative Writing & Informational Text Vocabulary Review
Quiz
•
8th Grade
18 questions
Informational Text Vocabulary
Quiz
•
7th - 8th Grade