Fungsi yang digunakan untuk pembacaan tabel yaitu ....
fungsi vlookup
10th Grade
•15 Qs
Similar activities
POST-TEST (X-8)
10th Grade - University
•10 Qs
Ôn Tập Các Hàm Trong Excel
KG - Professional Development
•20 Qs
Review Komputer Mid SMA (2)
10th Grade
•10 Qs
Quiz Spreadsheet 2
10th Grade
•11 Qs
SUMATIF 1 ANALISIS DATA
8th Grade - University
•16 Qs
Quiz Excel Dasar_Ovick Computer Academy
9th - 12th Grade
•20 Qs
Pretest Spreadsheet
10th Grade
•20 Qs
Ulangan Harian Analisis Data 8C
8th Grade - University
•20 Qs
fungsi vlookup
Quiz
•
Computers
•
10th Grade
•
Hard
Komang Wijaya
Used 92+ times
FREE Resource
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
IF
MAX
MIN
Lookup
Grafik
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi yang digunakan untuk pembacaan tabel yang letaknya vertikal atau tegak lurus yaitu ....
Lookup
Hlookup
Vlookup
IF
Logika
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi yang digunakan untuk pembacaan tabel yang letaknya horizontal atau sejajar yaitu ....
Lookup
Hlookup
Vlookup
Logika
Grafik
4.
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
=VLOOKUP(criteria cell;nama_tabel;no_kolom;0)
5.
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)
=HLOOKUP(A3;G2:h5;2)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Tombol yang digunakan untuk mengabsolutkan sell yaitu ....
F1
F2
F3
F4
F5
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Penulisan rumus VLOOKUP dibawah ini yang benar adalah ....
VLOOKUP(A3,G2:h5,2)
=VLOOKUP(A3,G2;h5,2)
=VLOOKUP(A3,G2:h5)
=HLOOKUP(A3,G2:h5,2)
=VLOOKUP(A3;G2:h5;2)
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
Ulangan Harian Aplikasi Pengolah Informasi
Quiz
•
10th Grade
20 questions
PTS Elemen Spreadsheet
Quiz
•
10th Grade
10 questions
Fungsi hlookup dan vlookup
Quiz
•
10th Grade
10 questions
Hlookup
Quiz
•
10th Grade
10 questions
Review Komputer Mid SMA (2)
Quiz
•
10th Grade
11 questions
Quiz Spreadsheet 2
Quiz
•
10th Grade
16 questions
SUMATIF 1 ANALISIS DATA
Quiz
•
8th Grade - University
10 questions
Quiz Fungsi Excel
Quiz
•
9th Grade - University
Popular Resources on Quizizz
15 questions
Character Analysis
Quiz
•
4th Grade
17 questions
Chapter 12 - Doing the Right Thing
Quiz
•
9th - 12th Grade
10 questions
American Flag
Quiz
•
1st - 2nd Grade
20 questions
Reading Comprehension
Quiz
•
5th Grade
30 questions
Linear Inequalities
Quiz
•
9th - 12th Grade
20 questions
Types of Credit
Quiz
•
9th - 12th Grade
18 questions
Full S.T.E.A.M. Ahead Summer Academy Pre-Test 24-25
Quiz
•
5th Grade
14 questions
Misplaced and Dangling Modifiers
Quiz
•
6th - 8th Grade
Discover more resources for Computers
17 questions
Chapter 12 - Doing the Right Thing
Quiz
•
9th - 12th Grade
20 questions
Types of Credit
Quiz
•
9th - 12th Grade
30 questions
Linear Inequalities
Quiz
•
9th - 12th Grade
20 questions
Taxes
Quiz
•
9th - 12th Grade
17 questions
Parts of Speech
Quiz
•
7th - 12th Grade
20 questions
Chapter 3 - Making a Good Impression
Quiz
•
9th - 12th Grade
20 questions
Inequalities Graphing
Quiz
•
9th - 12th Grade
10 questions
Identifying equations
Quiz
•
KG - University