Soal UB Kelas 8
8th Grade
•27 Qs
Similar activities
MS WORD 1
7th - 9th Grade
•25 Qs
Tes Sumatif Analisis Data
8th Grade
•23 Qs
Quiz Microsoft Excel
8th Grade - University
•25 Qs
Assesmen kelas 8 Materi Analisa Data ( Bab 5 )
8th Grade
•30 Qs
Pengenalan Spreadsheet
1st Grade - University
•25 Qs
TIK 8 Genap
8th Grade
•25 Qs
SUMATIF ANALISIS DATA
7th Grade - University
•25 Qs
Informatika
8th Grade
•25 Qs
Soal UB Kelas 8
Quiz
•
Computers
•
8th Grade
•
Medium
Herwan SMPITNF
Used 8+ times
FREE Resource
27 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Bagaimana cara menghitung rata-rata dari angka yang lebih dari 150?
=AVERAGE(A1)
=AVERAGEIF(A1,">150")
=SUMIF(A1,">150")/COUNTIF(A1,">150")
=IF(AVERAGE(A1)>150,"Benar","Salah")
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Teks di sel B1 berisi "AB123C". Anda ingin memeriksa apakah dua karakter pertama adalah huruf "AB". Rumus mana yang benar?
=IF(LEFT(B1,2)="AB","Benar","Salah")
=IF(MID(B1,1,2)="AB","Benar","Salah")
=IF(RIGHT(B1,2)="AB","Benar","Salah")
=IF(LEFT(B1,2)="A","Benar","Salah")
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Di kolom C, Anda memiliki data berikut: 70, 85, 90, 60, 50. Anda ingin menghitung jumlah total nilai yang lebih besar dari 65. Rumus apa yang Anda gunakan?
=SUM(C1)
=SUMIF(C1,">65")
=AVERAGEIF(C1,">65")
=MAX(C1,">65")
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Anda memiliki data teks "X987YZ" di sel D1. Bagaimana cara mengecek apakah tiga karakter terakhir adalah "YZ"?
=IF(LEFT(D1,3)="YZ","Benar","Salah")
=IF(MID(D1,5,2)="YZ","Benar","Salah")
=IF(RIGHT(D1,2)="YZ","Benar","Salah")
=IF(RIGHT(D1,3)="YZ","Benar","Salah")
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Anda ingin menampilkan "Bonus" jika nilai rata-rata di sel E1 hingga E5 lebih dari 75, dan "Tidak Bonus" jika kurang. Rumus apa yang benar?
=IF(SUM(E1)>75,"Bonus","Tidak Bonus")
=IF(AVERAGE(E1)>75,"Bonus","Tidak Bonus")
=IF(MAX(E1)>75,"Bonus","Tidak Bonus")
=IF(MIN(E1)>75,"Bonus","Tidak Bonus")
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Di sel F1 terdapat teks "B0023A". Bagaimana cara memastikan bahwa karakter ketiga hingga kelima adalah "002"?
=IF(MID(F1,3,3)="002","Benar","Salah")
=IF(LEFT(F1,3)="002","Benar","Salah")
=IF(RIGHT(F1,3)="002","Benar","Salah")
=IF(MID(F1,2,3)="002","Benar","Salah")
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Anda memiliki nilai penjualan bulanan di sel G1 hingga G6 dengan nilai 200, 300, 400, 500, 600, dan 700. Bagaimana cara mengetahui jika total penjualan melebihi 2500?
=IF(SUM(G1)>2500,"Target Tercapai","Target Belum Tercapai")
=IF(AVERAGE(G1)>2500,"Target Tercapai","Target Belum Tercapai")
=IF(MAX(G1)>2500,"Target Tercapai","Target Belum Tercapai")
=IF(MIN(G1)>2500,"Target Tercapai","Target Belum Tercapai")
Create a free account and access millions of resources
Similar Resources on Wayground
30 questions
Latihan Soal SAS 1 Informatika Kelas 8
Quiz
•
8th Grade
32 questions
ASKT2 : Bab 3 : a) Persekitaran Kod & Jenis Data
Quiz
•
8th Grade
25 questions
ASTS SEMESTER 2 TIK KELAS 8
Quiz
•
8th Grade - University
25 questions
UJIAN MID SEM 2 KELAS 8
Quiz
•
8th Grade - University
25 questions
UH TIK kelas 8 (Excel)
Quiz
•
8th Grade
32 questions
ASKT2 : Bab 3 : b) Pemalar / Pembolehubah & Input/Output
Quiz
•
8th - 9th Grade
25 questions
PENGENALAN MICROSOFT WORD
Quiz
•
7th - 12th Grade
25 questions
QUIZ ANALISIS DATA
Quiz
•
6th - 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
