Pencarian data di dalam aplikasi pengolah lembar kerja dapat dilakukan menggunakan fungsi?
Latihan
8th Grade
•15 Qs
Similar activities
Ôn Tập Các Hàm Trong Excel
KG - Professional Development
•20 Qs
Kuis VLOOKUP
8th Grade
•10 Qs
SUMATIF 1 ANALISIS DATA
8th Grade - University
•16 Qs
ANALISIS DATA KELAS 8
8th Grade
•10 Qs
Kuis Fungsi Lookup pada Microsoft Excel
8th Grade
•20 Qs
Analisis Data - Informatika
8th Grade
•15 Qs
TIK Kelas 8
7th - 9th Grade
•20 Qs
ANALISA DATA KELAS 8D 2024
8th Grade
•10 Qs
Latihan
Quiz
•
Computers
•
8th Grade
•
Hard
Lidzatus Saadah
FREE Resource
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
lookup
sum
average
count
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Rumus Formula yang digunakan untuk mencari data secara horisontal adalah ...
LOOKUP
VLOOKUP
HLOOKUP
AUTO SUM
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Bentuk umum penulisan rumus fungsi hlookup adalah ....
=HLOOKUP(nama_tabel;criteria cell;no_kolom;0)
=HLOOKUP(criteria cell;nama_tabel;no_kolom
=VLOOKUP(criteria cell;nama_tabel;no_kolom;0)
=HLOOKUP(criteria cell;nama_tabel;no_kolom;0)
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Penulisan rumus HLOOKUP dibawah ini yang benar adalah ....
=HLOOKUP(A3,G2;h5,2)
=HLOOKUP(A3;G2:h5;2)
=HLOOKUP(A3,G2:h5)
HLOOKUP(A3,G2:h5,2)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Penulisan rumus VLOOKUP dibawah ini yang benar adalah ....
=VLOOKUP(A3,G2:h5)
=VLOOKUP(A3,G2:h5)
=HLOOKUP(A3,G2:h5,2)
=VLOOKUP(A3;G2:h5;2)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Kode diatas yang berfungsi untuk mengulang langkah...
When space key pressed
Repeat
Move 50 steps
Turn 50 degress
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Kode tersebut berada di blok kode
Motion
Control
Events
Looks
Create a free account and access millions of resources
Create resources
Host any resource
Get auto-graded reports
Microsoft
Apple
Others
Similar Resources on Wayground
17 questions
Analisis Data
Quiz
•
8th Grade
20 questions
PSTS Informatika Kelas 8 (Genap)
Quiz
•
8th Grade
20 questions
Latihan soal Informatika Ecxel, Word , Power Point dan Pdf
Quiz
•
8th Grade - University
20 questions
UH Informatika Bab.VI
Quiz
•
8th Grade
20 questions
LATIHAN SOAL INFORMATIKA
Quiz
•
8th Grade
10 questions
ANALISIS DATA KELAS 8
Quiz
•
8th Grade
20 questions
Latihan Soal Fungsi Logika Di Ms. Excel
Quiz
•
8th Grade
15 questions
Analisis Data - Informatika
Quiz
•
8th Grade
Popular Resources on Wayground
25 questions
Equations of Circles
Quiz
•
10th - 11th Grade
30 questions
Week 5 Memory Builder 1 (Multiplication and Division Facts)
Quiz
•
9th Grade
33 questions
Unit 3 Summative - Summer School: Immune System
Quiz
•
10th Grade
10 questions
Writing and Identifying Ratios Practice
Quiz
•
5th - 6th Grade
36 questions
Prime and Composite Numbers
Quiz
•
5th Grade
14 questions
Exterior and Interior angles of Polygons
Quiz
•
8th Grade
37 questions
Camp Re-cap Week 1 (no regression)
Quiz
•
9th - 12th Grade
46 questions
Biology Semester 1 Review
Quiz
•
10th Grade