Pre Test SUMIF, COUNTIF, IF
Authored by Riyan Setiawan
Information Technology (IT)
9th Grade
Used 6+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Seorang guru ingin menghitung total nilai siswa yang mendapatkan nilai lebih dari 85 di mata pelajaran informatika. Kriteria apa yang harus digunakan dalam fungsi SUMIF?
"<85"
">85"
"=85"
"<>85"
2.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Jika bendahara kelas ingin mengetahui total anggaran yang digunakan untuk kegiatan P5, apa yang harus dimasukkan sebagai kriteria dalam fungsi SUMIF?
"Olahraga"
"P5"
"Seni"
"Kegiatan"
3.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Dalam fungsi SUMIF, manakah dari berikut ini yang benar untuk menghitung total kehadiran siswa di kelas 7B?
=SUMIF(range_kelas, "7A", range_kehadiran)
=SUMIF(range_kelas, "7B", range_kehadiran)
=SUMIF(range_kelas, "7C", range_kehadiran)
=SUMIF(range_kelas, "7D", range_kehadiran)
4.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Fungsi SUMIF membutuhkan minimal dua argumen: range dan criteria.
BENAR
SALAH
5.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
SUMIF hanya dapat digunakan untuk menjumlahkan data yang ada dalam satu kolom saja.
BENAR
SALAH
6.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Apa fungsi utama dari COUNTIF dalam Microsoft Excel?
Menjumlahkan angka berdasarkan kriteria tertentu
Menghitung jumlah sel yang memenuhi kriteria tertentu
Mencari nilai terbesar dalam satu rentang
Mengurutkan data dalam satu kolom
7.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Untuk menghitung jumlah siswa yang absen dengan kode "A" dalam satu kolom, bagaimana cara penulisan fungsi COUNTIF yang benar?
=COUNTIF(A2:A10, "A")
=COUNTIF(A2:A10, ">A")
=COUNTIF(A2:A10, "<A")
=COUNTIF(A2:A10, "=A")
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
15 questions
ASTS INFORMATIKA KELAS 9
Quiz
•
9th Grade
20 questions
ASESMEN DIAGNOSTIK INFORMATIKA KELAS 7
Quiz
•
7th Grade - University
10 questions
Dasar Rumus Microsoft Excel
Quiz
•
9th - 12th Grade
20 questions
BAB 5 ANALISIS DATA B. Membaca dan Menafsirkan Data KELAS 5
Quiz
•
5th Grade - University
20 questions
(8) Himpunan Data Terstruktur
Quiz
•
8th Grade - University
12 questions
ASAS INFORMATIKA IX 2425
Quiz
•
9th Grade
10 questions
Review Materi
Quiz
•
1st Grade - University
19 questions
Pseudocode
Quiz
•
9th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
10 questions
Probability Practice
Quiz
•
4th Grade
15 questions
Probability on Number LIne
Quiz
•
4th Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
6 questions
Appropriate Chromebook Usage
Lesson
•
7th Grade
10 questions
Greek Bases tele and phon
Quiz
•
6th - 8th Grade
Discover more resources for Information Technology (IT)
15 questions
Making Inferences
Quiz
•
7th - 12th Grade
20 questions
El Verbo IR Practice
Quiz
•
9th Grade
15 questions
Graphing Inequalities
Quiz
•
7th - 9th Grade
10 questions
Cell Organelles and Their Functions
Interactive video
•
6th - 10th Grade
20 questions
Graphing Inequalities on a Number Line
Quiz
•
6th - 9th Grade
15 questions
Combine Like Terms and Distributive Property
Quiz
•
8th - 9th Grade
10 questions
Plotting Points on a Coordinate Plane: Quadrant 1 Essentials
Interactive video
•
6th - 10th Grade
20 questions
Perfect Squares and Square Roots
Quiz
•
9th Grade