Informatics Quiz for 8th Grade
Authored by Ayu Lestari
Information Technology (IT)
8th Grade
Used 1+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Apa fungsi dari `IF` di Excel?
Menjumlahkan data
Menyaring data
Memberikan kondisi logis
Menyortir data
2.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Manakah dari berikut ini yang merupakan rumus `IF` yang benar?
=IF(A1>70, "Lulus", "Gagal")
=IF(A1<70; "Lulus", "Gagal")
=IF A1>70, Lulus, Gagal
IF(A1>70 = "Lulus", "Gagal")
3.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Apa yang dimaksud dengan `NESTED IF`?
IF digunakan untuk menghitung rata-rata
IF digunakan tanpa kondisi
IF bersarang (di dalam IF lain)
IF digunakan untuk menjumlahkan
4.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Amati rumus berikut: =IF(A1>90,"A",IF(A1>80,"B",IF(A1>70,"C","D"))) Apa output jika A1 adalah 85?
A
B
C
D
5.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Apa fungsi dari `SUMIF`?
Jumlahkan semua sel
Jumlahkan berdasarkan kondisi tertentu
Hitung karakter
Hapus data duplikat
6.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Bagaimana cara `VLOOKUP` mencari data?
Secara Vertikal
Secara Horizontal
Secara Acak
Secara Terurut
7.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Manakah dari berikut ini yang merupakan penggunaan `VLOOKUP` yang benar?
=VLOOKUP(B2;A2:D5;2;FALSE)
=VLOOKUP(A2;B2:C5;3)
=VLOOKUP(A2:A5;2;FALSE)
=VLOOKUP(A2,B2:D2,2)
Access all questions and much more by creating a free account
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
22 questions
Internet and App script
Quiz
•
5th Grade - University
20 questions
Quiz Informatika II
Quiz
•
8th Grade
20 questions
BAB 5 ANALISIS DATA A. Mengumpulkan Data KELAS 5
Quiz
•
5th Grade - University
20 questions
KELAS 7 BAB 6 ANALISIS DATA C. Pengolahan Data Dasar
Quiz
•
7th Grade - University
20 questions
Summative Assessment on Arduino Input Devices
Quiz
•
8th Grade
20 questions
Quiz Bab 2 Teknologi Informasi dan Komunikasi
Quiz
•
8th Grade
15 questions
Grade 6 - Living with AI
Quiz
•
6th Grade - University
18 questions
Asesmen Harian Informatika Kelas 7
Quiz
•
7th Grade - University
Popular Resources on Wayground
8 questions
Spartan Way - Classroom Responsible
Quiz
•
9th - 12th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
14 questions
Boundaries & Healthy Relationships
Lesson
•
6th - 8th Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
3 questions
Integrity and Your Health
Lesson
•
6th - 8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
9 questions
FOREST Perception
Lesson
•
KG
20 questions
Main Idea and Details
Quiz
•
5th Grade
Discover more resources for Information Technology (IT)
14 questions
Boundaries & Healthy Relationships
Lesson
•
6th - 8th Grade
3 questions
Integrity and Your Health
Lesson
•
6th - 8th Grade
7 questions
SMS Playground Expectations Quiz
Quiz
•
6th - 8th Grade
16 questions
Mario Trivia Challenge
Quiz
•
6th - 8th Grade
14 questions
SMS Car & Bus Expectations Quiz
Quiz
•
6th - 8th Grade
20 questions
Scatter Plots and Line of Best Fit
Quiz
•
8th Grade
12 questions
8th U6 L4 - Fitting a Line to Data
Quiz
•
8th Grade
22 questions
Phases of the moon
Quiz
•
8th Grade