POST TEST HLOOKUP VLOOKUP
12th Grade
•6 Qs
Similar activities
องค์ประกอบคอมพิวเตอร์
9th - 12th Grade
•10 Qs
Arduino
9th - 12th Grade
•10 Qs
LKPD INFORMATIKA
12th Grade
•10 Qs
Multimedia and desktop publishing
12th Grade
•10 Qs
Sociālie tīkli un drošība
1st - 12th Grade
•10 Qs
Learn When to Trust a Website and When to Avoid It
KG - University
•10 Qs
PERMAINAN KEPEKAAN
12th Grade
•10 Qs
ôn tập học kỳ 1-lớp 5
2nd Grade - University
•10 Qs
POST TEST HLOOKUP VLOOKUP
Quiz
•
Computers
•
12th Grade
•
Practice Problem
•
Hard
Rosma Lianti
Used 4+ times
FREE Resource
Enhance your content in a minute
6 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 15 pts
Jenis fungsi lookup yang datanya tersusun secara koordinat X horizontal adalah?
VLOOKUP
HLOOKUP
COUNTIF
MATCH
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Perhatikan tabel berikut!
Untuk mengisi sel D3 (JUMLAH), rumus yang digunakan adalah?
=Vlookup(B3;$A$11:$C$13;3)
=Hlookup(B3;$A$11:$C$13;3)
=Vlookup(B3;$A$11:$C$13;2)
=Vlookup(B3;$A$11:$C$13;2)
3.
MULTIPLE CHOICE QUESTION
1 min • 20 pts
Perhatikan tabel di atas ! Jika pada baris “ISI” diisi dengan rumus =VLOOKUP(A3,$A$2:$C$5,3)
Maka apa yang akan muncul?
Rp. 1.500.000
HANI
Rp. 1.000.000
GANJAR
4.
MULTIPLE CHOICE QUESTION
30 sec • 15 pts
Bentuk umum penulisan fungsi =Vlookup( ) adalah …
=Vlookup(range tabel, kunci, kolom ke)
=Vlookup( kolom ke, kunci, range tabel)
=Vlookup(kunci, range tabel, kolom ke)
=Vlookup(kolom ke, range tabel, kunci)
5.
MULTIPLE CHOICE QUESTION
1 min • 15 pts
Perhatikan tabel di samping!
Untuk mengisi sel C3 (NAMA BARANG), rumus yang digunakan adalah?
=Hlookup(B3;$A$11:$C$13;2)
=Vlookup(B3;$A$11:$C$13;1)
=Vlookup(B3;$A$11:$C$13;3)
=Vlookup(B3;$A$11:$C$13;2)
6.
MULTIPLE CHOICE QUESTION
1 min • 20 pts
Perhatikan tabel di atas ! Jika pada baris “ISI” diisi dengan rumus =VLOOKUP(A2;$A$2:$C2;2)
Maka apa yang akan muncul?
Rp. 1.000.000
GANJAR
Rp. 1.500.000
HANI
Similar Resources on Wayground
10 questions
4.0 Industria
Quiz
•
12th Grade
10 questions
DAMPAK SOSIAL INFORMATIKA
Quiz
•
9th - 12th Grade
10 questions
ASCII + Binary Representations
Quiz
•
5th - 12th Grade
10 questions
Gaming Trivia
Quiz
•
9th - 12th Grade
10 questions
Data Representation - Converting Denary to Binary
Quiz
•
3rd - 12th Grade
10 questions
Data Representation - Hexadecimal Number
Quiz
•
3rd - 12th Grade
9 questions
Unit 5 -- Lists, Loops, Traversals
Quiz
•
9th - 12th Grade
10 questions
统考电脑上册（29/9）
Quiz
•
12th Grade
Popular Resources on Wayground
5 questions
This is not a...winter edition (Drawing game)
Quiz
•
1st - 5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
Identify Iconic Christmas Movie Scenes
Interactive video
•
6th - 10th Grade
20 questions
Christmas Trivia
Quiz
•
6th - 8th Grade
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade
11 questions
How well do you know your Christmas Characters?
Lesson
•
3rd Grade
14 questions
Christmas Trivia
Quiz
•
5th Grade
20 questions
How the Grinch Stole Christmas
Quiz
•
5th Grade
Discover more resources for Computers
26 questions
Christmas Movie Trivia
Lesson
•
8th Grade - Professio...
15 questions
Christmas Song Emoji Pictionary
Quiz
•
7th - 12th Grade
20 questions
Christmas Movies
Quiz
•
1st - 12th Grade
55 questions
CHS Holiday Trivia
Quiz
•
12th Grade
20 questions
Christmas Movie Trivia
Quiz
•
9th - 12th Grade
29 questions
christmas facts
Lesson
•
5th - 12th Grade
20 questions
Christmas Trivia
Quiz
•
5th - 12th Grade
20 questions
Stages of Meiosis
Quiz
•
9th - 12th Grade