
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
48 questions
Graphing in Science
Quiz
•
6th - 9th Grade
54 questions
Midterm Review
Quiz
•
8th Grade
50 questions
7th and 8th Grade Science Review
Quiz
•
6th - 8th Grade
50 questions
FISIKA KELAS 8 SEM-1 TAPEL 2023/2024
Quiz
•
8th Grade
50 questions
Ujian Biologi Olimpiade SMP
Quiz
•
8th Grade
46 questions
Plate Tectonics Review
Quiz
•
6th - 8th Grade
47 questions
Q2 Benchmark Review
Quiz
•
8th Grade
50 questions
LGMSComp1AH_Q2
Quiz
•
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