SUMATIF 1 ANALISIS DATA
8th Grade
•16 Qs
Similar activities
Excel
8th Grade
•15 Qs
Review Komputer Mid SMA (1)
10th Grade
•20 Qs
UH Informatika Bab.VI
8th Grade
•20 Qs
fungsi vlookup
10th Grade
•15 Qs
Quiz Analisis Data Kelas 8
12th Grade
•20 Qs
IF and Vlookup Function
9th - 10th Grade
•15 Qs
spreadsheet
10th Grade
•11 Qs
Asessmen Pemahaman VLOOKUP dan HLOOKUP
8th Grade
•15 Qs
SUMATIF 1 ANALISIS DATA
Quiz
•
Computers
•
8th Grade
•
Hard
MUH. FITRANDA
FREE Resource
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
Similar Resources on Wayground
20 questions
Spreadsheet - Advanced Functions and Formulae
Quiz
•
10th - 11th Grade
20 questions
bab 3 bekerja dengan data dan modul komputasi kelas 9
Quiz
•
9th Grade
15 questions
Quiz Analisis Data Kelas VIII Informatika
Quiz
•
8th Grade
11 questions
Quiz 5: Internet safety, cyber security and encryption
Quiz
•
7th - 8th Grade
18 questions
MID Data analisis Kelas 8
Quiz
•
8th Grade
20 questions
Aplikasi Pengolah Angka
Quiz
•
12th Grade - University
15 questions
Pencarian data dan chart
Quiz
•
8th Grade
16 questions
ANALISIS DATA
Quiz
•
8th Grade
Popular Resources on Wayground
18 questions
Writing Launch Day 1
Lesson
•
3rd Grade
11 questions
Hallway & Bathroom Expectations
Quiz
•
6th - 8th Grade
11 questions
Standard Response Protocol
Quiz
•
6th - 8th Grade
40 questions
Algebra Review Topics
Quiz
•
9th - 12th Grade
4 questions
Exit Ticket 7/29
Quiz
•
8th Grade
10 questions
Lab Safety Procedures and Guidelines
Interactive video
•
6th - 10th Grade
19 questions
Handbook Overview
Lesson
•
9th - 12th Grade
20 questions
Subject-Verb Agreement
Quiz
•
9th Grade
Discover more resources for Computers
11 questions
Standard Response Protocol
Quiz
•
6th - 8th Grade
11 questions
Hallway & Bathroom Expectations
Quiz
•
6th - 8th Grade
10 questions
Lab Safety Procedures and Guidelines
Interactive video
•
6th - 10th Grade
4 questions
Exit Ticket 7/29
Quiz
•
8th Grade
24 questions
Flinn Lab Safety Quiz
Quiz
•
5th - 8th Grade
15 questions
Wren Pride and School Procedures Worksheet
Quiz
•
8th Grade
10 questions
Essential Lab Safety Practices
Interactive video
•
6th - 10th Grade
10 questions
Converting Repeating Decimals to Fractions
Quiz
•
8th Grade