Vlookup Hlookup
Authored by Nurbani Wulandari
Computers
9th - 12th Grade
Used 6+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
8 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Digunakan untuk menarik data secara vertikal adalah fungsi dari rumus ?
Hlookup
Max
Average
Vlookup
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Digunakan untuk menarik data secara horizontal adalah fungsi dari rumus ?
Hlookup
Max
Average
Vlookup
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Tombol apa yang digunakan untuk mengunci sel berisi rumus ?
F1
Ctrl
Alt
F4
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Bagaimana penulisan rumus Vlookup yang benar ?
=vlookup(sel pertama:sel terakhir)
=vlookup(nilai;"kondisi terpenuhi";"kondisi tidak terpenuhi")
=vlookup(Kata kunci;tabel referensi;nomor kolom;false)
=vlookup(range;"kriteria")
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Kenapa kita perlu mengunci sel tabel referensi ?
Agar tidak terbang
Agar datanya tidak geser
Agar sel nya berwarna
membuat teksnya tebal
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Manakah menu yang berfungsi untuk menampilkan mata uang ?
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Tegak lurus dari atas ke bawah atau sebaliknya di sebut..
Persegi
Vertikal
Lingkaran
Horizontal
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
10 questions
Post Test Excel Logika IF
Quiz
•
10th Grade
11 questions
algoritma
Quiz
•
12th Grade
10 questions
ASK TING 3 - KUIZ 1
Quiz
•
10th Grade
10 questions
Latihan soal kelas 8_Analisis Data (Pencarian Data)
Quiz
•
9th - 12th Grade
10 questions
Quiz Excel 3
Quiz
•
10th Grade
10 questions
TEST KOMPETENSI AWAL ANALISIS DATA
Quiz
•
9th Grade
12 questions
Ms. Excel Rev
Quiz
•
8th - 11th Grade
10 questions
Quiz Sesi Kedua
Quiz
•
1st - 12th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
