Informatika
Authored by Ni Juliani
Mathematics
7th - 9th Grade
Used 15+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
2 mins • 5 pts
Fungsi yang digunakan untuk melakukan penjumlahan dengaan banyak kritria/kondisi tertentu adalah....
SUMIF
SUMIFS
SUM
COUNTIF
2.
MULTIPLE CHOICE QUESTION
2 mins • 5 pts
Fungsi yang digunakan untuk mencari nilai tertinggi pada range tertentu adalah....
SUM
MIN
MAX
AVERAGE
3.
MULTIPLE CHOICE QUESTION
2 mins • 5 pts
Mengurutkan data dari yang terkecil ke terbesar menggunakan menu...
All Border
Merge and Center
Sort Ascending
Sort Descending
4.
MULTIPLE CHOICE QUESTION
2 mins • 5 pts
Rumus untuk menentukan JUMLAH DETERGEN Adalah...
=SUM(A2:A9 ; "Detergen" ; D2:D9)
=SUMIFS(A2:A9 ; "Detergen" ; D2:D9)
=SUMIF(A2:A9 ; "Detergen" ; D2:D9)
=SUMIF(D2:D9 ; "Detergen" ; A2:A9)
5.
MULTIPLE CHOICE QUESTION
2 mins • 5 pts
Rumus yang tepat untuk menentukan jumlah SABUN BESAR adalah....
=SUMIFS(D2:D9 ; A2:A9 ; "Sabun" ; C2:C9 ; "Besar")
=SUMIFS(D2:D9 ; A2:A9 ; "Sabun" ; B2:B9 ; "Besar")
=SUMIF(D2:D9 ; B2:B9 ; "Sabun" ; C2:C9 ; "Besar")
=SUMIFS(D2:D9 ; B2:B9 ; "Sabun" ; C2:C9 ; "Besar")
6.
MULTIPLE CHOICE QUESTION
2 mins • 5 pts
Pada perintah SUMIFS yang pertama kita lakukn setelah rumus =SUMIFS(.......
Blok Sum Range / Kolom Stok
Blok Range Kondisi 1 / Blok Kolom Kondisi 1
Blok Range Kondisi 2 / Blok Kolom Kondisi 2
Panggil Kondisi
7.
MULTIPLE CHOICE QUESTION
2 mins • 5 pts
Hasil dari SUM dan Countnya adalah...
SUM = 8 dan COUNT = 150
SUM = 8 dan COUNT = 155
SUM = 150 dan COUNT = 8
SUM = 155 dan COUNT = 8
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
20 questions
Area Regular Polygons
Quiz
•
9th - 12th Grade
15 questions
Area / Perimeter / Circumference Quiz
Quiz
•
6th - 8th Grade
20 questions
PA Review Exponents 1.6
Quiz
•
8th - 9th Grade
18 questions
FACTORING BY GROUPING
Quiz
•
8th - 9th Grade
20 questions
Les bases de la géométrie
Quiz
•
8th Grade
17 questions
Áreas y volúmenes
Quiz
•
6th Grade - University
15 questions
Circumference Quiz
Quiz
•
7th Grade
15 questions
Daudzstūru laukumi un citi prieki
Quiz
•
8th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
Discover more resources for Mathematics
22 questions
distributive property
Quiz
•
7th Grade
18 questions
Angle Relationships
Quiz
•
7th Grade
20 questions
How Some Friendships Last — and Others Don’t Video Questions
Quiz
•
7th Grade
14 questions
finding slope from a graph
Quiz
•
8th Grade
18 questions
Handbook Refresher Quiz
Quiz
•
7th Grade
20 questions
Laws of Exponents
Quiz
•
8th Grade
12 questions
8th U5L9 Linear Models
Quiz
•
8th Grade
20 questions
Graphing Inequalities on a Number Line
Quiz
•
6th - 9th Grade