Spreadsheet 3
8th Grade
•36 Qs
Similar activities
สอบแก้ตัว Midterm ม.2 วิทยาการคำนวณ
8th Grade
•40 Qs
CIW IBA 1st 9 Weeks Quiz
7th - 8th Grade
•40 Qs
he
8th - 10th Grade
•38 Qs
Computing Fundamentals Pt 2
6th - 8th Grade
•35 Qs
KIỂM TRA HỌC KỲ 2- TIN 7
6th - 8th Grade
•40 Qs
Informatika 8-2
7th - 9th Grade
•38 Qs
CS Discoveries Unit 1-3 Overview
6th - 8th Grade
•32 Qs
LATIHAN SOAL ASTS GENAP INFORMATIKA 8
8th Grade
•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")
Create a free account and access millions of resources
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
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
Similar Resources on Wayground
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
35 questions
Database
Quiz
•
KG - University
31 questions
Excel Skills Review
Quiz
•
KG - University
36 questions
GCSE ICT U1 Topics 1-6 Revision
Quiz
•
5th - 9th Grade
33 questions
Summative Review
Quiz
•
6th - 8th Grade
Popular Resources on Wayground
10 questions
Honoring the Significance of Veterans Day
Interactive video
•
6th - 10th Grade
9 questions
FOREST Community of Caring
Lesson
•
1st - 5th Grade
10 questions
Exploring Veterans Day: Facts and Celebrations for Kids
Interactive video
•
6th - 10th Grade
19 questions
Veterans Day
Quiz
•
5th Grade
14 questions
General Technology Use Quiz
Quiz
•
8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
Circuits, Light Energy, and Forces
Quiz
•
5th Grade
19 questions
Thanksgiving Trivia
Quiz
•
6th Grade