Spreadsheet 3
8th Grade
•36 Qs
Similar activities
Unit 9.1 - Textual Programming
8th Grade - University
•35 Qs
VEX IQ
8th Grade
•33 Qs
Python Programming
5th - 9th Grade
•37 Qs
KS3 Computing Terms A
7th - 9th Grade
•32 Qs
ICR - Data Types & Flowcharts
6th - 8th Grade
•41 Qs
lembar Asesmen Aktivitas 11
6th - 8th Grade
•40 Qs
Google Classroom & Meet
6th - 12th Grade
•32 Qs
Excel Unit Review
6th - 12th Grade
•31 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
40 questions
LATIHAN SOAL ASTS GENAP INFORMATIKA 8
Quiz
•
8th Grade
40 questions
Latihan PAT
Quiz
•
8th Grade
40 questions
Introduction to Computers
Quiz
•
6th - 8th Grade
40 questions
HTML Basics
Quiz
•
6th - 8th Grade
38 questions
EV3 SENSORS
Quiz
•
6th - 8th Grade
40 questions
Spreadsheet Formulas,Charts,Formatting
Quiz
•
7th - 8th Grade
40 questions
Информатика -140: 2024 1-нұсқа талдау ақылы
Quiz
•
8th Grade
31 questions
Grade 4- review lesson- exploring email-s2
Quiz
•
3rd - 10th 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
