Pencarian data dan chart
8th Grade
•15 Qs
Similar activities
Objects
8th - 12th Grade
•16 Qs
UTS 8 S2 2425
8th Grade
•10 Qs
Nat 5 Standard Algorithms + Predefined Functions
8th - 10th Grade
•10 Qs
Python Quiz
3rd Grade - Professional Development
•11 Qs
Quiz Fungsi VLOOKUP dan HLOOKUP 8E
8th Grade
•10 Qs
LAT SOAL INFORMATIKA
8th Grade
•20 Qs
Python Skills
1st Grade - Professional Development
•15 Qs
Mảng 1 chiều
8th - 11th Grade
•15 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
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
Similar Resources on Wayground
20 questions
Bài 11: KIỂU MẢNG MỘT CHỀU
Quiz
•
1st - 10th Grade
20 questions
Keterampilan Fungsi Lookup
Quiz
•
8th Grade
10 questions
Ulangan Harian Bab 6
Quiz
•
8th Grade
20 questions
Pra Simulasi Sumatif Tahun Ajaran 2024/2025
Quiz
•
8th Grade
10 questions
Arrays and Lists
Quiz
•
6th - 12th Grade
12 questions
SOAL LATIHAN ASTS GENAP KELAS 8
Quiz
•
8th Grade
10 questions
Materi Lookup dan Vlookup
Quiz
•
8th Grade
20 questions
KELAS 8 TRY OUT ASLM 1 GENAP
Quiz
•
8th Grade
Popular Resources on Wayground
10 questions
Video Games
Quiz
•
6th - 12th Grade
20 questions
Brand Labels
Quiz
•
5th - 12th Grade
15 questions
Core 4 of Customer Service - Student Edition
Quiz
•
6th - 8th Grade
15 questions
What is Bullying?- Bullying Lesson Series 6-12
Lesson
•
11th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
Subtracting Integers
Quiz
•
7th Grade
22 questions
Adding Integers
Quiz
•
6th Grade
10 questions
Exploring Digital Citizenship Essentials
Interactive video
•
6th - 10th Grade
Discover more resources for Computers
10 questions
Exploring Digital Citizenship Essentials
Interactive video
•
6th - 10th Grade
18 questions
Company Logos
Quiz
•
6th - 8th Grade
10 questions
Proper Keyboarding Techniques
Interactive video
•
6th - 10th Grade
14 questions
Inputs and Outputs: Computer Science Intro
Lesson
•
5th - 9th Grade
10 questions
Understanding Computers: Hardware, Software, and Operating Systems
Interactive video
•
7th - 12th Grade