
9. ULANGAN HARIAN 2 24
Quiz
•
Science
•
8th Grade
•
Practice Problem
•
Hard
AMIN THOHARI
Used 12+ times
FREE Resource
50 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi SUM dalam Excel digunakan untuk…
Menghitung rata-rata data
Menjumlahkan nilai data
Menghitung jumlah data
Menemukan nilai tertinggi dari data
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Rumus =SUM(10, 20, 30) akan menghasilkan nilai…
50
60
70
80
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi SUMIFS berbeda dengan SUMIF karena…
Hanya bisa menjumlahkan satu nilai
Hanya digunakan pada satu sel
Digunakan untuk menghitung jumlah data
Dapat memiliki lebih dari satu kriteria
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Manakah dari berikut ini yang merupakan sintaks dasar dari fungsi SUMIF?
=SUMIF(range, criteria, [sum_range])
=SUMIF(criteria, range)
=SUMIF(range, criteria)
=SUMIF([sum_range], range)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Jika kamu menggunakan fungsi =SUM(B2:B5), berapakah hasil yang akan muncul?
250
240
260
270
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Berdasarkan tabel di atas, jika kamu hanya ingin menjumlahkan nilai siswa dengan nilai lebih dari 80 di kolom "Nilai 1", rumus manakah yang benar?
=SUMIF(B2:B5, ">80")
=SUMIF(C2:C5, ">80")
=SUMIF(A2:A5, ">80")
=SUMIF(B2:B5, ">=80")
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Manakah rumus yang digunakan untuk menjumlahkan nilai siswa di kelas 7A?
=SUMIF(B2:B5, "7A", C2:C5)
=SUMIFS(C2:C5, B2:B5, "7A")
=SUMIF(A2:A5, "7A", C2:C5)
=SUMIFS(B2:B5, C2:C5, "7A")
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
47 questions
SAINS ting 2- sistem suria& meteroid
Quiz
•
8th Grade
50 questions
Pelestarian Lingkungan
Quiz
•
7th - 12th Grade
51 questions
Earth Inside-Out Unit
Quiz
•
5th - 8th Grade
54 questions
Waves
Quiz
•
8th Grade
50 questions
IPA 9
Quiz
•
7th - 9th Grade
50 questions
Kejuruan Teknik Bisnis dan Sepeda Motor
Quiz
•
KG - Professional Dev...
51 questions
Thermal Energy Heat Transfer 2023
Quiz
•
8th Grade
45 questions
Engineering Design Process
Quiz
•
6th - 8th Grade
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 Science
20 questions
Physical and Chemical Changes
Quiz
•
8th Grade
22 questions
Newton's Laws of Motion
Lesson
•
8th Grade
12 questions
Phases of Matter
Quiz
•
8th Grade
20 questions
Distance Time Graphs
Quiz
•
6th - 8th Grade
21 questions
Balanced and Unbalanced Forces
Quiz
•
8th Grade
10 questions
Exploring Newton's Laws of Motion
Interactive video
•
6th - 10th Grade
12 questions
Speed, Velocity, and Acceleration
Lesson
•
6th - 8th Grade
19 questions
Forces and Motion
Lesson
•
6th - 8th Grade