LATIHAN SOAL ASTS GENAP INFORMATIKA 8
8th Grade
•40 Qs
Similar activities
ASESMEN SUMATIF AKHIR TAHUN - INFORMATIKA KELAS 7
7th Grade - University
•35 Qs
MS office 2016
1st Grade - Professional Development
•40 Qs
The Internet
6th - 8th Grade
•40 Qs
Internet Safety (37)
8th Grade
•37 Qs
Ôn tập tin học 7
8th Grade
•44 Qs
Algorithms - Pseudocode & Flowcharts
8th Grade
•39 Qs
Quiz-PTS2-TIK Gr4
4th Grade - University
•45 Qs
ULANGAN HARIAN KE-3 KELAS VIII
8th Grade
•40 Qs
LATIHAN SOAL ASTS GENAP INFORMATIKA 8
Quiz
•
Computers
•
8th Grade
•
Practice Problem
•
Easy
Riski Lutfiani
Used 339+ times
FREE Resource
Enhance your content in a minute
40 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Perhatikan data berikut!
(1) SLOOKUP
(2) HLOOKUP
(3) XLOOKUP
(4) VLOOKUP
Yang termasuk fungsi LOOKUP adalah nomor ... .
1 dan 2
1 dan 3
2 dan 4
4 saja
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Untuk mencari tinggi badan pada tabel tersebut, kita harus menggunakan fungsi ... .
HLOOKUP
LOOKUP
CLOOKUP
VLOOKUP
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Rumus untuk mencari nama customer adalah ... .
=HLOOKUP(B3;$G$2:$J$12;4;FALSE)
=VLOOKUP(B3;$G$2:$J$12;4;FALSE)
=VLOOKUP(B3;$G$2:$J$12;2;FALSE)
=HLOOKUP(B3;$G$2:$J$12;2;FALSE)
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
rumus untuk mencari tinggi badan pada tabel tersebut adalah ... .
=HLOOKUP(B3;$F$9:$K$10:2;FALSE)
=HLOOKUP(B3;$F$9:$K$10:1;FALSE)
=VLOOKUP(B3;$F$9:$K$10:2;FALSE)
=VLOOKUP(B3;$F$9:$K$10:1;FALSE)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Perbedaan HLOOKUP dan VLOOKUP yang tepat adalah ... .
ketika data disajika dalam bentuk vertical, maka bisa menggunakan fungsi HLOOKUP untuk pencarian data
HLOOKUP dapat digunakan untuk menghitung data yag disajikan dalam bentuk horizontal
ketika data disajikan dalam bentuk vertical maka bisa menggunakan fungsi VLOOKUP untuk pencarian data
VLOOKUP dapat digunakan untuk menghitung data yang disajikan dalam bentuk vertical
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Perhatikan data berikut!
(1) MATCH
(2) VLOOKUP
(3) CHOOSE
(4) INDEX
Yang termasuk fungsi REFERENCE adalah ... .
1 dan 3
1,3,4
2 dan 4
2,3,4
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi utama fungsi INDEX adalah ... .
menampilkan nilai terbesar dalam suatu range
mengurutkan data dalam tabel
menghasilkan nilai elemen pada tabel berdasarkan nomor indeks baris dan kolom
menghitung jumlah total dalam suatu range
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
45 questions
Internet y redes
Quiz
•
6th - 12th Grade
37 questions
Algorithm: Flowcharts
Quiz
•
8th - 10th Grade
40 questions
Scratch - Introduction to Coding
Quiz
•
6th - 8th Grade
40 questions
Soal-Soal Microsoft Excel
Quiz
•
8th Grade
45 questions
Microsoft Excel - Basics
Quiz
•
7th Grade - University
45 questions
GCSE Python Legends
Quiz
•
1st - 12th Grade
39 questions
Test Excel 1
Quiz
•
8th Grade
40 questions
QUIZZ KJD - PERAWATAN, PERMASALAHAN DAN PERBAIKAN PC
Quiz
•
KG - Professional Dev...
Popular Resources on Wayground
5 questions
This is not a...winter edition (Drawing game)
Quiz
•
1st - 5th Grade
15 questions
4:3 Model Multiplication of Decimals by Whole Numbers
Quiz
•
5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
The Best Christmas Pageant Ever Chapters 1 & 2
Quiz
•
4th Grade
12 questions
Unit 4 Review Day
Quiz
•
3rd 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