Perhatikan Tabel berikut ! Tabel acuan ini tepat digunakan dengan RUMUS .....
LOOKUP
9th Grade
•20 Qs
Similar activities
TIK Kelas 8
7th - 9th Grade
•20 Qs
Kuis 2 - PKS 1
University
•20 Qs
Soal Ulangan kelas 8-Analisis Data
12th Grade
•20 Qs
Pretest Spreadsheet
10th Grade
•20 Qs
VLOOKUP/HLOOKUP IGCSE Grade 11
10th - 11th Grade
•17 Qs
Fungsi Dasar pada Microsoft Excel
11th Grade
•15 Qs
Kuis Excel 1
12th Grade
•20 Qs
PTS GENAP DDAKL SPEADSHEET 2025
10th Grade - University
•25 Qs
LOOKUP
Quiz
•
Computers
•
9th Grade
•
Medium
Nurul Rahayu
Used 135+ times
FREE Resource
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
=VLOOKUP
=IF
=RIGHT
=MID
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Perhatikan Tabel Acuan Berikut ! Rumus yang tepat untuk digunakan adalah...
=VLOOKUP
=IF
=RIGHT
=HLOOKUP
3.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Perhatikan Rumus VLOOKUP berikut, manakah bagian yang menunjukkan Lookup value ?
VLOOKUP
B19:E26
B7
0
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Perhatikan Rumus HLOOKUP berikut! Bagian mana yang menunjukkan table_array?
A5
B28:I29
2
FALSE
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Perhatikan Rumus HLOOKUP berikut !, Bagian mana yang menunjukkan col_index_num ?
A5
B28:I29
2
0
6.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
Fungsi yang digunakan untuk pembacaan tabel yang letaknya vertikal atau tegak lurus yaitu ....
Lookup
VLOOKUP
HLOOKUP
IF
7.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Fungsi yang digunakan untuk pembacaan tabel yang letaknya horizontal atau sejajar yaitu ....
LOOKUP
VLOOKUP
COUNT
HLOOKUP
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
16 questions
SUMATIF 1 ANALISIS DATA
Quiz
•
8th Grade - University
20 questions
Kuis Excel 1
Quiz
•
12th Grade
20 questions
PTS Elemen Spreadsheet
Quiz
•
10th Grade
20 questions
Kuis Informatika kelas X TF dan KDS
Quiz
•
10th Grade
20 questions
QUIZ MICROSOFT EXCEL_LEVEL MUDA
Quiz
•
11th Grade
25 questions
ASESMEN TENGAH SEMESTER
Quiz
•
8th Grade - University
25 questions
EXCEL
Quiz
•
11th Grade
20 questions
Quiz Excel Dasar_Ovick Computer Academy
Quiz
•
9th - 12th Grade
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
30 questions
Linear Inequalities
Quiz
•
9th - 12th Grade
20 questions
Types of Credit
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