SUMIFS dan COUNTIFS
8th Grade
•15 Qs
Similar activities
informatika analisis data kelas 8
8th Grade
•20 Qs
Quis TIK Excell
8th Grade
•20 Qs
Soal Analisis Data Kelas 8
8th Grade
•10 Qs
AS 1 INFORMATIKA 8
8th Grade
•20 Qs
Asesmen Awal Analisis Data Kelas 8 SMP
8th Grade
•15 Qs
Assesmen Sumatif Berfikir Komputasional Kelas 8
8th Grade
•15 Qs
TIK KD 3
1st - 12th Grade
•20 Qs
Advanced Excel
KG - University
•20 Qs
SUMIFS dan COUNTIFS
Quiz
•
Computers
•
8th Grade
•
Practice Problem
•
Hard
Ni S.pd.
Used 4+ 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
15 questions
Mengenal Jendela dan Ikon Microsoft Excel
Quiz
•
7th Grade - University
20 questions
Quiz Brain Rot
Quiz
•
8th Grade
10 questions
Visualisasi Data
Quiz
•
8th Grade
20 questions
ASTS Kelas 7 "Ms. Excel"
Quiz
•
7th Grade - University
15 questions
analisis data 8
Quiz
•
8th Grade
20 questions
PTS INFORMATIKA
Quiz
•
8th Grade
20 questions
PH BERFIKIR KOMPUTISIONAL
Quiz
•
8th Grade
20 questions
Quiz Microsoft Excel
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
