Jenis fungsi lookup yang datanya tersusun secara koordinat X horizontal adalah?
POST TEST HLOOKUP VLOOKUP
12th Grade
•6 Qs
Similar activities
Laporan Keuangan Spreadsheet
KG - Professional Development
•10 Qs
Aplikasi Pengolah Angka/Spreadsheet Kls X
12th Grade
•10 Qs
Asesmen Formatif Google Sheet - Part 1
11th Grade - University
•10 Qs
KOMPUTER AKUNTANSI
10th - 12th Grade
•10 Qs
Ms Excel 101 Series - Intermediate Level
12th Grade
•10 Qs
Latihan soal kelas 8_Analisis Data (Pencarian Data)
9th - 12th Grade
•10 Qs
Quiz Fungsi Excel
9th Grade - University
•10 Qs
Mastering Class : Data Analysis using Spreadsheet and GDS
1st - 12th Grade
•8 Qs
POST TEST HLOOKUP VLOOKUP
Quiz
•
Computers
•
12th Grade
•
Hard
Rosma Lianti
Used 3+ times
FREE Resource
6 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 15 pts
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 Quizizz
10 questions
REMEDIAL SIMDIG - US TP. 2023/2024
Quiz
•
12th Grade
10 questions
Quiz Fungsi Excel
Quiz
•
9th Grade - University
10 questions
Pemahaman excel
Quiz
•
9th - 12th Grade
10 questions
Asesmen Formatif Google Sheet - Part 1
Quiz
•
11th Grade - University
10 questions
Fungsi HLOOKUP dan VLOOKUP
Quiz
•
12th Grade
10 questions
INFORMATIKA 1 - OFFICE
Quiz
•
9th - 12th Grade
10 questions
Kuis_ Informatika_SMA KELAS X
Quiz
•
9th - 12th Grade
10 questions
KT8_DM1902
Quiz
•
12th Grade
Popular Resources on Quizizz
15 questions
Multiplication Facts
Quiz
•
4th Grade
20 questions
Math Review - Grade 6
Quiz
•
6th Grade
20 questions
math review
Quiz
•
4th Grade
5 questions
capitalization in sentences
Quiz
•
5th - 8th Grade
10 questions
Juneteenth History and Significance
Interactive video
•
5th - 8th Grade
15 questions
Adding and Subtracting Fractions
Quiz
•
5th Grade
10 questions
R2H Day One Internship Expectation Review Guidelines
Quiz
•
Professional Development
12 questions
Dividing Fractions
Quiz
•
6th Grade