Asesmen Formatif Peringkasan Data
Quiz
•
Information Technology (IT)
•
8th Grade
•
Hard
Susanto Susanto
Used 3+ times
FREE Resource
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
2 mins • 10 pts
Dalam data pemilihan ketua OSIS, fungsi =IF(D2=MAX(D2:D6), "Terpilih", "Tidak Terpilih") digunakan untuk…
2.
MULTIPLE CHOICE QUESTION
2 mins • 10 pts
Jika calon ketua OSIS dianggap "Populer" saat mendapat suara lebih dari 130, rumus IF yang tepat untuk menentukan status ini adalah…
3.
MULTIPLE CHOICE QUESTION
2 mins • 10 pts
Untuk memberikan keterangan:
A. ≥140 = "Sangat Populer"
B. 120–139 = "Populer"
C. <120 = "Cukup Populer"
Fungsi NESTED IF yang tepat adalah…
4.
MULTIPLE CHOICE QUESTION
2 mins • 10 pts
Untuk menghitung total suara yang diperoleh oleh calon perempuan, rumus SUMIF yang digunakan adalah…
=SUMIF(E2:E6, "Perempuan", D2:D6)
=SUMIF(D2:D6, "Perempuan", E2:E6)
=SUMIF(E2:E6, "Laki-laki", D2:D6)
=SUMIF(D2:D6, E2:E6, "Perempuan")
5.
MULTIPLE CHOICE QUESTION
5 mins • 10 pts
Dalam tabel pemilihan, calon dengan suara 135 termasuk kategori apa jika digunakan rumus:
=IF(D2>=140,"Sangat Populer",IF(D2>=120,"Populer","Cukup Populer"))
Populer
Cukup Populer
6.
FILL IN THE BLANK QUESTION
5 mins • 10 pts
Proses menyederhanakan data agar lebih mudah dianalisis disebut...
7.
FILL IN THE BLANK QUESTION
3 mins • 10 pts
Fungsi untuk menguji suatu kondisi dalam Excel adalah fungsi...
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
10 questions
Quiz Pengetahuan Umum Komputer
Quiz
•
3rd Grade - University
10 questions
Mengkaji Kritis Informasi Digital
Quiz
•
8th Grade
10 questions
Uji Pengetahuan Teknologi Informasi
Quiz
•
8th Grade
10 questions
Quiz Excel 1 kelas 8
Quiz
•
8th Grade
10 questions
Câu hỏi về hàm SUMIF
Quiz
•
8th Grade
15 questions
TJBL
Quiz
•
6th - 8th Grade
15 questions
Sistem Komputer
Quiz
•
5th Grade - University
15 questions
Kelas 7 - Halaman 12 (UH Bab 1)
Quiz
•
7th Grade - University
Popular Resources on Wayground
20 questions
Brand Labels
Quiz
•
5th - 12th Grade
11 questions
NEASC Extended Advisory
Lesson
•
9th - 12th Grade
10 questions
Ice Breaker Trivia: Food from Around the World
Quiz
•
3rd - 12th Grade
10 questions
Boomer ⚡ Zoomer - Holiday Movies
Quiz
•
KG - University
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
Adding Integers
Quiz
•
6th Grade
10 questions
Multiplication and Division Unknowns
Quiz
•
3rd Grade
20 questions
Multiplying and Dividing Integers
Quiz
•
7th Grade
Discover more resources for Information Technology (IT)
10 questions
Ice Breaker Trivia: Food from Around the World
Quiz
•
3rd - 12th Grade
20 questions
Brand Labels
Quiz
•
5th - 12th Grade
10 questions
Boomer ⚡ Zoomer - Holiday Movies
Quiz
•
KG - University
20 questions
Figurative Language Review
Quiz
•
8th Grade
20 questions
Physical and Chemical Changes
Quiz
•
8th Grade
22 questions
Newton's Laws of Motion
Lesson
•
8th Grade
24 questions
3.1 Parallel lines cut by a transversal
Quiz
•
8th Grade
12 questions
Phases of Matter
Quiz
•
8th Grade