Spreadsheet 3
8th Grade
•36 Qs
Similar activities
Excel
1st Grade - University
•40 Qs
ASKT2 : Bab 3 : b) Pemalar / Pembolehubah & Input/Output
8th - 9th Grade
•32 Qs
MYE Revision 7 & 8
7th - 8th Grade
•35 Qs
OCR GCSE 1.5 Systems Software MCQs
8th - 10th Grade
•34 Qs
Banana Tales - CodeMonkey
6th - 8th Grade
•37 Qs
Soal PTS Kelas 8 Informatika
8th Grade
•40 Qs
Web Dev MasterClass Day1
6th Grade - Professional Development
•34 Qs
Pre Test STS Informatika 7 2025/2026
7th Grade - University
•36 Qs
Spreadsheet 3
Quiz
•
Computers
•
8th Grade
•
Practice Problem
•
Medium
Ahmad Rohman
Used 5+ times
FREE Resource
Enhance your content in a minute
36 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Berdasarkan gambar di atas, fungsi yang digunakan untuk mengisi kolom D/Keterangan adalah ...
fungsi AND
fungsi OR
fungsi IF
fungsi XOR
fungsi logika
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Berdasarkan gambar di atas, fungsi yang benar untuk mengisi kolom D adalah ...
=if(C2>20,”DITERIMA”,”DITOLAK”)
=if(C2<20,”DITERIMA”,”DITOLAK”)
=if(D2>20,”DITERIMA”,”DITOLAK”)
=if(C2>20,DITERIMA,DITOLAK)
=if(C3>20:”DITERIMA”:”DITOLAK”)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Untuk mengambil kata "ELLI" dari kata "ARTIFICIAL INTELLIGENCE" rumus yang benar adalah . . .
=RIGHT(“ARTIFICIAL INTELLIGENCE”,15,4)
=LEFT(“ARTIFICIAL INTELLIGENCE”,9)
=MID(“ARTIFICIAL INTELLIGENCE”,9)
=MID(“ARTIFICIAL INTELLIGENCE”,15,4)
=MID(“ARTIFICIAL INTELLIGENCE”,14,4)
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Untuk mengambil kata "ARTI" dari kata "ARTIFICIAL INTELLIGENCE" rumus yang benar adalah . . .
=RIGHT(“ARTIFICIAL INTELLIGENCE”,4)
=LEFT(“ARTIFICIAL INTELLIGENCE”,4)
=LEFT(D3,4)
=LEFT(ARTIFICIAL INTELLIGENCE,4)
=MID(“ARTIFICIAL INTELLIGENCE”,14,4)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Untuk mengambil kata "NCE" dari kata "ARTIFICIAL INTELLIGENCE" rumus yang benar adalah . . .
=RIGHT(“ARTIFICIAL INTELLIGENCE”,3)
=LEFT(“ARTIFICIAL INTELLIGENCE”,4)
=LEFT(D3,4)
=LEFT(ARTIFICIAL INTELLIGENCE,4)
=MID(“ARTIFICIAL INTELLIGENCE”,14,4)
6.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
Berdasarkan gambar di atas, sintak/rumus untuk mengisi SEL C2 yang benar adalah ...
=IF(B2 !=M;MERAH;PUTIH)
=IF(B2="P";"PUTIH";"MERAH")
=IF(B2="M";”MERAH”;”PUTIH”)
=IF(C2 = ”M”;”PUTIH”;”MERAH”)
=IF(C2=M;”MERAH”;”PUTIH”)
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Terdapat data nilai siswa dalam sel A1,A2 dan A3 dengan nilai masing-masing A1 = 75, A2 = 60, dan A3 = 50. Terdapat ketentuan seperti berikut jika nilai > 75 tampilkan "Lulus" jika nilai >= 60 "Lulus bersyarat" Jika nilai dibawah 60 "Tidak Lulus" rumus yang benar dibawah ini adalah. . .
=IF(A1 >= 75, "Lulus", IF(A1>=60,”Lulus bersyarat”,"Tidak Lulus")
=IF(A1 >= 75, Lulus, IFA1>=60,Lulus bersyarat,Tidak Lulus)
=IF(A1 > 60, "Lulus", “Lulus bersyarat”,"Tidak Lulus")
=IF(A1 < 60, "Lulus", "Tidak Lulus")
=IF(A1 != 60, "Lulus", “Lulus bersyarat”,"Tidak Lulus")
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
33 questions
Summative Review
Quiz
•
6th - 8th Grade
36 questions
Using Photo Story 3
Quiz
•
8th Grade
40 questions
PERTANYAAN UNTUK SISWA KELAS 8 INFORMATIKA
Quiz
•
8th Grade
32 questions
Y8 Binary revision
Quiz
•
8th Grade
40 questions
HTML assessment
Quiz
•
7th - 8th Grade
31 questions
Excel Skills Review
Quiz
•
KG - University
35 questions
Database
Quiz
•
KG - University
36 questions
GCSE ICT U1 Topics 1-6 Revision
Quiz
•
5th - 9th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
20 questions
Figurative Language Review
Quiz
•
6th Grade
