Kuiz VIII
Quiz
•
Computers
•
•
Medium
Irmaliza Efniwingrum
Used 15+ times
FREE Resource
30 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Rumus yang digunakan untuk menampilkan semua Nama Barang pada tabel di samping adalah ..
=VLOOKUP(A3,$A$13:$D$16,2,FALSE)
=VLOOKUP(A3,$A$13:$D$16,3,FALSE)
=VLOOKUP(A3,$A$13:$D$16,4,FALSE)
=VLOOKUP(A3,$A$13:$D$16,0,FALSE)
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Rumus yang digunakan untuk menampilkan Harga pada tabel di samping adalah...
=VLOOKUP(A3,$A$13:$D$16,2,FALSE)
=VLOOKUP(A3,$A$13:$D$16,3,FALSE)
=VLOOKUP(A3,$A$13:$D$16,4,FALSE)
=VLOOKUP(A3,$A$13:$D$16,0,FALSE)
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Rumus yang digunakan untuk menampilkan Satuan pada tabel di samping adalah ….
=VLOOKUP(A3,$A$13:$D$16,3,FALSE)
=VLOOKUP(A3,$A$13:$D$16,2,FALSE)
=VLOOKUP(A3,$A$13:$D$16,0,FALSE)
=VLOOKUP(A3,$A$13:$D$16,4,FALSE)
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Rumus yang digunakan untuk menampilkan Nama Barang pada tabel di samping adalah …
=HLOOKUP(G2,$H$11:$K$14,4,FALSE)
=HLOOKUP(G2,$H$11:$K$14,3,FALSE)
=HLOOKUP(G2,$H$11:$K$14,2,FALSE)
=HLOOKUP(G2,$H$11:$K$14,1,FALSE)
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Rumus yang digunakan untuk menampilkan Harga pada tabel di samping adalah …
=HLOOKUP(G2,$H$11:$K$14,4,FALSE)
=HLOOKUP(G2,$H$11:$K$14,2,FALSE)
=HLOOKUP(G2,$H$11:$K$14,3,FALSE)
=HLOOKUP(G2,$H$11:$K$14,1,FALSE)
6.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Rumus yang digunakan untuk menampilkan Satuan pada tabel di samping adalah …
=HLOOKUP(G2,$H$11:$K$14,1,FALSE)
=HLOOKUP(G2,$H$11:$K$14,2,FALSE)
=HLOOKUP(G2,$H$11:$K$14,3,FALSE)
=HLOOKUP(G2,$H$11:$K$14,4,FALSE)
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Tabel Acuan pada gambar di samping digunakan untuk membaca data secara …..
Vertikal
Horizontal
Diagonal
Dari atas ke bawah
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
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
Similar Resources on Wayground
25 questions
ASTS SEMESTER 2 TIK KELAS 8
Quiz
•
8th Grade - University
35 questions
ASLM Genap Analisis Data
Quiz
•
8th Grade
33 questions
Latihan Soal Kelas 7
Quiz
•
7th Grade
25 questions
Excel functions and formulas assessment
Quiz
•
9th - 11th Grade
25 questions
Quiz Visualisasi Data dan Fungsi Excel
Quiz
•
1st Grade
25 questions
PTS TIK 2023
Quiz
•
9th - 12th Grade
25 questions
TRY OUT ASLM 1 KELAS 9 AD
Quiz
•
9th Grade
25 questions
Quiz Analisis Data
Quiz
•
8th Grade
Popular Resources on Wayground
20 questions
Brand Labels
Quiz
•
5th - 12th Grade
10 questions
Ice Breaker Trivia: Food from Around the World
Quiz
•
3rd - 12th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
20 questions
ELA Advisory Review
Quiz
•
7th Grade
15 questions
Subtracting Integers
Quiz
•
7th Grade
22 questions
Adding Integers
Quiz
•
6th Grade
10 questions
Multiplication and Division Unknowns
Quiz
•
3rd Grade
10 questions
Exploring Digital Citizenship Essentials
Interactive video
•
6th - 10th Grade
Discover more resources for Computers
10 questions
Exploring Digital Citizenship Essentials
Interactive video
•
6th - 10th Grade
25 questions
Exploring POV and Unreliable Narrators
Quiz
•
7th Grade
18 questions
Company Logos
Quiz
•
6th - 8th Grade
30 questions
Computer Terminology Exercise #1 ( Fill Ins)
Quiz
•
9th Grade
15 questions
MLA Formatting
Quiz
•
9th Grade
20 questions
Typing Practice
Quiz
•
7th - 12th Grade
14 questions
Inputs and Outputs: Computer Science Intro
Lesson
•
5th - 9th Grade
16 questions
4.2 Private & Personal Information
Lesson
•
4th Grade