Berdasarkan gambar di atas, fungsi yang digunakan untuk mengisi kolom D/Keterangan adalah ...
Spreadsheet KD 3.10
1st - 2nd Grade
•20 Qs
Similar activities
Peter and The Wolf
2nd - 5th Grade
•15 Qs
Gambar Teknik X UTS Sem 1 SMKN6 Bdg
1st Grade
•15 Qs
[Kelas 7 SMP] Bab 3 - Rumus COUNT, COUNTA, COUNTIF
1st - 12th Grade
•17 Qs
SImulasi PAS SIMDIG
1st - 10th Grade
•25 Qs
excel maret 2020
1st Grade
•20 Qs
Persekitaran Kod Arahan
2nd Grade
•20 Qs
Pengetahuan Umum VI
1st - 12th Grade
•20 Qs
TIK Mandiri I
2nd Grade
•20 Qs
Spreadsheet KD 3.10
Quiz
•
Other
•
1st - 2nd Grade
•
Hard
Ita Anggraini
Used 6+ times
FREE Resource
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
fungsi AND
fungsi OR
fungsi XOR
fungsi logika
fungsi IF
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Berdasarkan gambar di atas, sintak/rumus untuk mengisi SEL D2 adalah adalah ...
=IF(B2<20;"DITOLAK";"DITERIMA")
=IF(D2>20;"DITERIMA";"DITOLAK ")
=IF(C2<20;"DITERIMA";"DITOLAK")
=IF(C2>20;"DITOLAK";"DITERIMA")
=IF(C2<20;"DITOLAK";"DITERIMA")
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Berdasarkan gambar di atas, sintak/rumus untuk mengisi SEL C2 adalah adalah ...
=IF(C2=”M”;”MERAH”;”PUTIH”)
=IF(C2=”M”;”PUTIH”;”MERAH”)
=IF(B2=M;MERAH;PUTIH)
=IF(B2=”M”;”PUTIH”;”MERAH”)
=IF(B2=”M”;”MERAH”;”PUTIH”)
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Berdasarkan gambar di atas, sintak/rumus untuk mengisi SEL D5 adalah adalah ...
=IF(C5>20;"DITOLAK";"DITERIMA")
=IF(C5<20;"DITERIMA";"DITOLAK")
=IF(B5>20;"DITERIMA";"DITOLAK")
=IF(D5<20;"DITOLAK";"DITERIMA ")
=IF(C5>20;"DITERIMA";"DITOLAK")
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Berdasarkan gambar di atas, sintak/rumus untuk mengisi SEL C5 adalah ...
=IF(C5=”P”;”MERAH”;”PUTIH”)
=IF(C5=”P”;”PUTIH”;”MERAH”)
=IF(B5=P;MERAH;PUTIH)
=IF(B5=”P”;”MERAH”;”PUTIH”)
=IF(B5=”P”;”PUTIH”;”MERAH”)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Berdasarkan gambar, fungsi yang digunakan untuk mengisi SEL B6 adalah ....
fungsi Hlookup
fungsi Vlookup
fungsi String LEFT
fungsi String Right
fungsi String MID
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Berdasarkan gambar, rumus yang digunakan untuk menghasilkan kata yang terdapat pada SEL B7 adalah ....
=MID(B7;3;4)
=MID(A7;3;4)
=MID(A7;3)
=LEFT(A7;3;4)
=RIGHT(A7;3;5)
Create a free account and access millions of resources
Create resources
Host any resource
Get auto-graded reports
Microsoft
Apple
Others
Similar Resources on Quizizz
20 questions
Latihan Soal Pramuka Siaga SD Strada Cakung
Quiz
•
1st - 5th Grade
20 questions
Game TIK Kelas 2 MIPA
Quiz
•
1st - 2nd Grade
20 questions
Kerajinan objek budaya lokal
Quiz
•
1st - 5th Grade
20 questions
excel maret 2020
Quiz
•
1st Grade
20 questions
Persekitaran Kod Arahan
Quiz
•
2nd Grade
20 questions
ULANGAN HARIAN INSTALASI MOTOR LISTRIK
Quiz
•
2nd Grade
15 questions
t2 bm kosa kata 1
Quiz
•
2nd Grade
15 questions
Soal Pengetahuan Kepramukaan
Quiz
•
1st Grade
Popular Resources on Quizizz
15 questions
Multiplication Facts
Quiz
•
4th Grade
25 questions
SS Combined Advisory Quiz
Quiz
•
6th - 8th Grade
40 questions
Week 4 Student In Class Practice Set
Quiz
•
9th - 12th Grade
40 questions
SOL: ILE DNA Tech, Gen, Evol 2025
Quiz
•
9th - 12th Grade
20 questions
NC Universities (R2H)
Quiz
•
9th - 12th Grade
15 questions
June Review Quiz
Quiz
•
Professional Development
20 questions
Congruent and Similar Triangles
Quiz
•
8th Grade
25 questions
Triangle Inequalities
Quiz
•
10th - 12th Grade