HLOOKUP
Quiz
•
Other
•
10th Grade
•
Practice Problem
•
Hard
Rida Prasetyo
Used 53+ times
FREE Resource
Enhance your content in a minute
17 questions
Show all answers
1.
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
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi yang digunakan untuk pembacaan tabel yang letaknya horizontal atau sejajar yaitu ....
Lookup
Hlookup
Vlookup
Logika
Grafik
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Penulisan rumus HLOOKUP dibawah ini yang benar adalah ....
HLOOKUP(A3,G2:h5,2;0)
=HLOOKUP(A3,G2;h5,2,0)
=HLOOKUP(A3,G2:h5,0)
=HLOOKUP(A3,G2:h5,2,0)
=HLOOKUP(A3,G2:h5,2,0)
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Penggunaan rumus Hlookup dan Vlookup langkahnya hampir sama. Perbedaannya terletak pada penggunaan ....
Pointernya
Menekan enter
Tabel bantunya
Fungsinya
Tanda kurungnya
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Penulisan rumus VLOOKUP dibawah ini yang benar adalah ....
VLOOKUP(A3,G2:h5,2;0)
=VLOOKUP(A3,G2;h5,2,0)
=VLOOKUP(A3,G2:h5,0)
=HLOOKUP(A3,G2:h5,2,0)
=VLOOKUP(A3,G2:h5,2,0)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Perhatikan Rumus VLOOKUP berikut! Bagian mana yang menunjukkan table_array
VLOOKUP
2
$B$11:$D$14
LEFT(C3;1)
FALSE
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Perhatikan table array Berikut ! cocok digunakan untuk RUMUS ?
=VLOOKUP
=HLOOKUP
=IF
=LEFT
=RIGHT
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
15 questions
Teknik Pengambilan Sampel Subjek Penelitian
Quiz
•
10th Grade
20 questions
小論文概論與格式說明
Quiz
•
10th Grade
20 questions
Gambar Teknik Otomotif ( GTO )
Quiz
•
10th Grade
20 questions
LATIHA US MATEMATIKA BARISAN DERET
Quiz
•
10th Grade
15 questions
Materi1 Mengenal Program Ms. Excel
Quiz
•
10th Grade
20 questions
Kuis Kihajar SMP 14 Bandar Lampung
Quiz
•
7th - 12th Grade
20 questions
UAS SPREADSHEET X AKUNTANSI
Quiz
•
10th Grade
20 questions
Circuitos en Corriente Directa
Quiz
•
10th - 12th Grade
Popular Resources on Wayground
7 questions
History of Valentine's Day
Interactive video
•
4th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
15 questions
Valentine's Day Trivia
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
Discover more resources for Other
10 questions
Exploring Valentine's Day with Charlie Brown
Interactive video
•
6th - 10th Grade
18 questions
Valentines Day Trivia
Quiz
•
3rd Grade - University
20 questions
-AR -ER -IR present tense
Quiz
•
10th - 12th Grade
10 questions
Valentine's Day History and Traditions
Interactive video
•
6th - 10th Grade
21 questions
Presidents Day Trivia
Quiz
•
6th - 12th Grade
10 questions
Valentine's Day: History and Modern Celebration
Interactive video
•
9th - 12th Grade
11 questions
Valentine's Day Trivia
Quiz
•
8th - 12th Grade
10 questions
Factor Quadratic Expressions with Various Coefficients
Quiz
•
9th - 12th Grade
