Spreadsheet KD 3.10
Authored by Ita Anggraini
Other
1st - 2nd Grade
Used 6+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Berdasarkan gambar di atas, fungsi yang digunakan untuk mengisi kolom D/Keterangan adalah ...
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)
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
20 questions
Axle Wheel Suspenssion
Quiz
•
1st - 12th Grade
15 questions
PROJEK BRIEF
Quiz
•
1st Grade
20 questions
Wawasan Nusantara (Kelas X)
Quiz
•
1st Grade
25 questions
Ukbm 4
Quiz
•
2nd Grade
15 questions
Administrasi Umum
Quiz
•
1st Grade
15 questions
Sarana dan Prasarana Kantoir
Quiz
•
2nd Grade
15 questions
Peter and The Wolf
Quiz
•
2nd - 5th Grade
15 questions
Elementary Music Trivia!
Quiz
•
KG - 5th 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
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th 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
Discover more resources for Other
20 questions
Telling Time to the Hour and Half hour
Quiz
•
1st Grade
22 questions
Equal Groups and Arrays
Quiz
•
2nd Grade
10 questions
Life Cycle of a Frog
Quiz
•
1st - 2nd Grade
10 questions
Exploring Rosa Parks and Black History Month
Interactive video
•
1st - 5th Grade
20 questions
Counting Coins
Quiz
•
2nd Grade
20 questions
Place Value
Quiz
•
KG - 3rd Grade
30 questions
DA Math Mania Bowl - Primary
Quiz
•
2nd Grade
19 questions
Subject-Verb Agreement
Quiz
•
2nd - 5th Grade