Spreadsheet 3
8th Grade
•36 Qs
Similar activities
CK1 TIN 8 (24-25)
8th Grade
•31 Qs
Digital Art Semester Review
7th - 8th Grade
•40 Qs
GIMP tools
8th Grade
•38 Qs
UH - SUMATIF INFORMATIKA 8 - ALGORITMA & PEMROGRAMAN (SCRACTH)
8th Grade
•40 Qs
JavaScript Test 2
7th - 8th Grade
•32 Qs
REVIEW FINAL TEST (KOMPUTER - CALEB)
8th Grade
•40 Qs
LO1 iMedia
7th - 10th Grade
•31 Qs
PowerPoint 2016
7th Grade - University
•40 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
36 questions
ASK TINGKATAN 1 BAB 4 : KOD ARAHAN
Quiz
•
8th Grade
34 questions
Lesson 6 Databases & Web Search Engines
Quiz
•
8th Grade
35 questions
Microsoft Word
Quiz
•
6th - 12th Grade
38 questions
Database basics for key stage 3
Quiz
•
7th - 9th Grade
35 questions
Chapter 9 Review: Word Processors
Quiz
•
8th Grade
40 questions
soal pts tik 8 semester 1
Quiz
•
8th Grade
33 questions
Computer Components
Quiz
•
7th - 11th Grade
33 questions
Ôn Tập KTCK2 Tin 8 22-23
Quiz
•
8th 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
