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
10 questions
Tin 9 Bài 8. Hàm SUMIF
Quiz
•
9th Grade - University
15 questions
Quiz 3. Struktur Data
Quiz
•
8th Grade - University
15 questions
BAB 4 | 4.1 KOD ARAHAN | SUBTOPIK 4.1.2
Quiz
•
2nd Grade - University
15 questions
Quiz Analisis Data
Quiz
•
8th Grade - University
20 questions
Quiz Struktur Data Graf
Quiz
•
9th Grade
12 questions
Algoritma dan Pemrograman
Quiz
•
9th - 12th Grade
20 questions
Soal QuIz SMPIT IF Meningkatkan Kemampuan Berpikir
Quiz
•
9th Grade
20 questions
ASESMEN DIAGNOSTIK INFORMATIKA KELAS 9
Quiz
•
9th Grade - University
Popular Resources on Wayground
7 questions
History of Valentine's Day
Interactive video
•
4th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
15 questions
Valentine's Day Trivia
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
Discover more resources for Information Technology (IT)
10 questions
Exploring Valentine's Day with Charlie Brown
Interactive video
•
6th - 10th Grade
18 questions
Valentines Day Trivia
Quiz
•
3rd Grade - University
20 questions
El Verbo IR Practice
Quiz
•
9th Grade
10 questions
Valentine's Day History and Traditions
Interactive video
•
6th - 10th Grade
20 questions
Graphing Inequalities on a Number Line
Quiz
•
6th - 9th Grade
20 questions
Exponent Properties
Quiz
•
9th Grade
21 questions
Presidents Day Trivia
Quiz
•
6th - 12th Grade
10 questions
Valentine's Day: History and Modern Celebration
Interactive video
•
9th - 12th Grade