Kuiz VIII
30 Qs
Similar activities
Test Formatif ANALISIS DATA kelas XII
12th Grade
•25 Qs
MS Excel - p1 - 30câu - SP
KG
•30 Qs
Excel Basics #1
7th Grade
•25 Qs
L-7 Ms-Excel
4th - 6th Grade
•25 Qs
UH X6
10th Grade
•25 Qs
Informatika AKL 1
1st Grade
•25 Qs
ATS K9
9th Grade - University
•30 Qs
UTS TEKNOLOGI PERKANTORAN SEMESTER II
1st Grade
•25 Qs
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
UH 1 Exel 8
Quiz
•
8th Grade
25 questions
PAT TIK Kelas 8
Quiz
•
12th Grade
25 questions
Latihan PAT 1 - INFORMATIKA 8
Quiz
•
8th Grade
25 questions
Review MySQL
Quiz
•
Professional Development
29 questions
REPASO HOJA DE CÁLCULO
Quiz
•
Professional Development
35 questions
Spreadsheets
Quiz
•
7th - 8th Grade
25 questions
2nd Part Semester Test Review
Quiz
•
7th - 8th Grade
25 questions
Analisis Data Ulangan Harian 1
Quiz
•
8th Grade
Popular Resources on Wayground
10 questions
Honoring the Significance of Veterans Day
Interactive video
•
6th - 10th Grade
10 questions
Exploring Veterans Day: Facts and Celebrations for Kids
Interactive video
•
6th - 10th Grade
19 questions
Veterans Day
Quiz
•
5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
Circuits, Light Energy, and Forces
Quiz
•
5th Grade
6 questions
FOREST Self-Discipline
Lesson
•
1st - 5th Grade
7 questions
Veteran's Day
Interactive video
•
3rd Grade
20 questions
Weekly Prefix check #2
Quiz
•
4th - 7th Grade