Berdasarkan gambar di atas, fungsi yang digunakan untuk mengisi kolom D/Keterangan adalah ...
Spreadsheet KD 3.10
1st - 2nd Grade
•20 Qs
Similar activities
Pengetahuan Umum VI
1st - 12th Grade
•20 Qs
ULANGAN HARIAN INSTALASI MOTOR LISTRIK
2nd Grade
•20 Qs
PTS TIK 9 SEMESTER 1 2022
1st Grade
•20 Qs
Peter and The Wolf
2nd - 5th Grade
•15 Qs
t2 bm kosa kata 1
2nd Grade
•15 Qs
Basic 03
1st Grade
•15 Qs
THI KẾT THÚC MÔN TIN HỌC ĐỀ 2
1st Grade
•20 Qs
Kerajinan objek budaya lokal
1st - 5th 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
excel maret 2020
Quiz
•
1st Grade
20 questions
Persekitaran Kod Arahan
Quiz
•
2nd Grade
15 questions
Soal Pengetahuan Kepramukaan
Quiz
•
1st Grade
20 questions
Latihan Soal Pramuka Siaga SD Strada Cakung
Quiz
•
1st - 5th Grade
15 questions
WAWASAN WIYATA MANDALA
Quiz
•
1st Grade
15 questions
Musical Instruments quiz
Quiz
•
2nd - 3rd Grade
16 questions
Kuis Analisis Regresi Linier Sederhana
Quiz
•
1st Grade
15 questions
SMAW Teori Melaksanakan Persiapan Tempat Kerja (C.25LAS01.001.1)
Quiz
•
1st Grade
Popular Resources on Quizizz
15 questions
Multiplication Facts
Quiz
•
4th Grade
20 questions
Math Review - Grade 6
Quiz
•
6th Grade
20 questions
math review
Quiz
•
4th Grade
5 questions
capitalization in sentences
Quiz
•
5th - 8th Grade
10 questions
Juneteenth History and Significance
Interactive video
•
5th - 8th Grade
15 questions
Adding and Subtracting Fractions
Quiz
•
5th Grade
10 questions
R2H Day One Internship Expectation Review Guidelines
Quiz
•
Professional Development
12 questions
Dividing Fractions
Quiz
•
6th Grade