SUMIFS dan COUNTIFS
8th Grade
•15 Qs
Similar activities
TIK Kelas VIII
8th Grade
•10 Qs
KELAS 7 Bab 6 Analisis DAta D. Pengolahan Data Lanjutan
7th Grade - University
•20 Qs
TIK Excel Kelas VIII
8th Grade
•20 Qs
Ms Excel
6th - 8th Grade
•10 Qs
Analisis Data
8th Grade
•13 Qs
Ulangan Harian (Analisis Data) Kelas 7
6th - 8th Grade
•20 Qs
Operasi Matematika Sederhana Dengan Excel
1st - 10th Grade
•10 Qs
Latihan PAT Informatika Kelas 8
8th 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
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
Already have an account?
Similar Resources on Wayground
20 questions
PTS TIK Kelas 8 Semester Ganjil
Quiz
•
8th Grade
10 questions
INFOR ANALISIS DATA
Quiz
•
8th Grade
10 questions
Quiz 2 KLS 8
Quiz
•
8th Grade
20 questions
Pengenalan Microsoft Excel
Quiz
•
8th - 9th Grade
20 questions
QUIZ INFORMATIKA KELAS 8
Quiz
•
8th Grade
14 questions
Assesment Formatif Akhir Bab I Berpikir Komputasional Kelas VIII
Quiz
•
8th Grade
20 questions
UH - 01 VII
Quiz
•
1st - 12th Grade
20 questions
Review Materi Ms. Excel
Quiz
•
6th - 8th Grade
Popular Resources on Wayground
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
4:3 Model Multiplication of Decimals by Whole Numbers
Quiz
•
5th Grade
10 questions
The Best Christmas Pageant Ever Chapters 1 & 2
Quiz
•
4th Grade
12 questions
Unit 4 Review Day
Quiz
•
3rd Grade
20 questions
Christmas Trivia
Quiz
•
6th - 8th Grade
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade
14 questions
Christmas Trivia
Quiz
•
5th Grade
15 questions
Solving Equations with Variables on Both Sides Review
Quiz
•
8th Grade