Fungsi yang digunakan untuk pembacaan tabel yaitu ....

Quiz Fungsi Hlookup dan Vlookup

Quiz
•
Information Technology (IT)
•
9th Grade
•
Hard
Rusniati Rusniati
Used 2+ times
FREE Resource
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
IF
MAX
MIN
Lookup
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi yang digunakan untuk pembacaan tabel yang letaknya vertikal atau tegak lurus yaitu ....
Lookup
Hlookup
Vlookup
Logika
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi yang digunakan untuk pembacaan tabel yang letaknya horizontal atau sejajar yaitu ....
Lookup
Hlookup
Vlookup
Grafik
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Program Excel digunakan untuk ....
Presentasi
Mengolah kata
Mengolah angka
Basis data
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Bentuk umum penulisan rumus fungsi hlookup adalah ....
=HLOOKUP(criteria cell;nama_tabel;no_kolom;0)
=HLOOKUP(nama_tabel;criteria cell;no_kolom;0)
HLOOKUP(criteria cell;nama_tabel;no_kolom;0)
=HLOOKUP(criteria cell;nama_tabel;no_kolom
6.
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)
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Penulisan formula dalam microsoft office excel selalu diawali dengan tanda ....
+
=
*
x
Create a free account and access millions of resources
Similar Resources on Wayground
10 questions
Quiz Google Sheets

Quiz
•
9th Grade
20 questions
Excel / Spreadsheet Basic fo Coding Juara

Quiz
•
9th - 12th Grade
15 questions
Latihan Analisis Data Kelas 9

Quiz
•
9th Grade
20 questions
Uji Pengetahuan Informatika

Quiz
•
9th Grade
15 questions
Sumatif 2-TIK Kelas 8

Quiz
•
8th Grade - University
20 questions
Informatika

Quiz
•
8th Grade - University
20 questions
PENILAIAN TENGAH SEMESTER GENAP IX A

Quiz
•
9th Grade
10 questions
Quiz Google Sheets

Quiz
•
9th 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