SUMIFS dan COUNTIFS
8th Grade
•15 Qs
Similar activities
Quiz Microsoft Excel #2
8th Grade
•14 Qs
Kuis Informatika 1
7th - 9th Grade
•20 Qs
Fungsi VLOOKUP dan HLOOKUP
8th Grade
•20 Qs
Kuis Analisis Data kelas 8
8th Grade
•10 Qs
ASESMEN SUMATIF BK. 1.4 KELAS 8
8th Grade
•15 Qs
Pencarian Data pada Microsoft Excel
8th Grade
•15 Qs
Microsoft excel
8th Grade
•20 Qs
TEKWAN
1st - 12th Grade
•20 Qs
SUMIFS dan COUNTIFS
Quiz
•
Computers
•
8th Grade
•
Practice Problem
•
Hard
Ni S.pd.
Used 3+ times
FREE Resource
Enhance your content in a minute
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Fungsi yang digunakan untuk menjumlahkan nilai dalam rentang yang memenuhi beberapa kriteria adalah...
SUM
AVERAGE
SUMIF
SUMIFS
2.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Fungsi yang digunakan untuk menghitung banyak data dalam rentang yang memenuhi beberapa kriteria adalah...
a) COUNT
b) COUNTA
c) COUNTIF
d) COUNTIFS
3.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Sintaks dasar fungsi SUMIFS adalah...
=SUMIFS(sum_range, criteria_range1, criteria1, ...)
=SUMIFS(criteria_range1, criteria1, sum_range, ...)
=SUMIFS(range, criteria, sum_range)
=SUMIFS(sum_range, criteria)
4.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Sintaks dasar fungsi COUNTIFS adalah...
=COUNTIFS(range, criteria)
=COUNTIFS(criteria_range1, criteria1, ...)
=COUNTIFS(range1, criteria1, range2, criteria2, sum_range)
=COUNTIFS(criteria1, criteria_range1, ...)
5.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Dalam fungsi SUMIFS, argumen sum_range merujuk pada...
Rentang sel yang akan dievaluasi berdasarkan kriteria.
Kriteria yang akan diterapkan pada rentang sel.
Rentang sel yang berisi nilai yang akan dijumlahkan.
Sel tunggal yang berisi nilai yang akan dijumlahkan.
6.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Dalam fungsi COUNTIFS, argumen criteria_range merujuk pada...
Rentang sel yang berisi nilai yang akan dijumlahkan.
Kriteria yang akan diterapkan pada rentang sel.
Rentang sel yang akan dievaluasi berdasarkan kriteria.
Sel tunggal yang berisi kriteria.
7.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Apa yang akan dihasilkan oleh formula =SUMIFS(C1:C10, A1:A10, "A", B1:B10, ">5") jika rentang A1:A10 berisi {"A", "B", "A", "C", "A", "B", "A", "C", "A", "B"}, rentang B1:B10 berisi {3, 7, 6, 2, 9, 4, 8, 1, 5, 10}, dan rentang C1:C10 berisi {10, 20, 15, 5, 25, 10, 20, 5, 15, 30}?
50
70
60
45
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
BAB 2 - PEMBUATAN DOKUMEN MICROSOFT EXCEL (KELAS 8 Bagian I)
Quiz
•
8th Grade
20 questions
Quiz PTS Informatika 8
Quiz
•
8th Grade
15 questions
Quiz Analisis Data Kelas VIII Informatika
Quiz
•
8th Grade
10 questions
ANALISA DATA KELAS 8D 2024
Quiz
•
8th Grade
20 questions
TIK KELAS 8
Quiz
•
8th Grade
20 questions
pengenalan jendela pengolah angka
Quiz
•
8th Grade
20 questions
Ms. Excel Dasar 1
Quiz
•
8th Grade
18 questions
ComPizza questions supplémentaires
Quiz
•
8th - 9th 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
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
20 questions
Figurative Language Review
Quiz
•
6th Grade
