LOOKUP
9th Grade
•20 Qs
Similar activities
Soal Formatif Microsoft Excel
9th Grade
•20 Qs
Ulangan 1 - Konsep Multimedia Interaktif
12th Grade
•15 Qs
POST TEST WEB STATIC
University - Professional Development
•20 Qs
Quiz TIK Excel
11th Grade
•15 Qs
Teknologi Perkantoran
10th Grade
•20 Qs
Databases and Normalisation
12th Grade
•20 Qs
Kuis 2 - PKS 1
University
•20 Qs
EXCEL 11
11th Grade
•20 Qs
LOOKUP
Quiz
•
Computers
•
9th Grade
•
Practice Problem
•
Medium
Nurul Rahayu
Used 138+ times
FREE Resource
Enhance your content in a minute
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Perhatikan Tabel berikut ! Tabel acuan ini tepat digunakan dengan RUMUS .....
=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
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
22 questions
Ms. Excel
Quiz
•
University
20 questions
Quiz informatika Berpikir Komputasional
Quiz
•
9th Grade
15 questions
Ulangan 1 - Konsep Multimedia Interaktif
Quiz
•
12th Grade
20 questions
Teknologi Perkantoran
Quiz
•
10th Grade
20 questions
Databases and Normalisation
Quiz
•
12th Grade
20 questions
Kuis 2 - PKS 1
Quiz
•
University
20 questions
Latihan SAT Informatika Kelas X TA-2324
Quiz
•
10th Grade
20 questions
bab 3 bekerja dengan data dan modul komputasi kelas 9
Quiz
•
9th Grade
Popular Resources on Wayground
10 questions
Honoring the Significance of Veterans Day
Interactive video
•
6th - 10th Grade
9 questions
FOREST Community of Caring
Lesson
•
1st - 5th Grade
10 questions
Exploring Veterans Day: Facts and Celebrations for Kids
Interactive video
•
6th - 10th Grade
19 questions
Veterans Day
Quiz
•
5th Grade
14 questions
General Technology Use Quiz
Quiz
•
8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
Circuits, Light Energy, and Forces
Quiz
•
5th Grade
19 questions
Thanksgiving Trivia
Quiz
•
6th Grade