Analisis Data
8th Grade
•25 Qs
Similar activities
P5 Editor
4th - 8th Grade
•20 Qs
ICT Grade 8 Model exam Altaluq private school Excel
8th Grade
•20 Qs
CS
8th - 9th Grade
•20 Qs
BERPIKIR KOMPUTASIONAL 10.12
1st Grade - University
•20 Qs
pengenalan jendela pengolah angka
8th Grade
•20 Qs
ESB Practice Quiz Lessons 1 and 2
7th - 12th Grade
•20 Qs
Networking
8th Grade
•20 Qs
Excel Lesson 3 Review
7th - 8th Grade
•20 Qs
Analisis Data
Quiz
•
Computers
•
8th Grade
•
Practice Problem
•
Hard
Intan NZ
Used 7+ times
FREE Resource
Enhance your content in a minute
25 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
COUNTIFS dapat digunakan untuk menghitung berapa kali suatu kondisi terpenuhi berdasarkan:
Satu kriteria
Dua kriteria
Tiga kriteria
Empat kriteria
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Apa fungsi utama COUNTIFS dalam Excel?
Menghitung jumlah sel yang memenuhi beberapa kriteria
Menghitung jumlah sel yang kosong
Menghitung jumlah sel dalam satu kriteria
Menghitung rata-rata sel tertentu
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi COUNTIFS dapat digunakan pada:
Microsoft PowerPoint
Microsoft Word
Microsoft Excel
Microsoft Outlook
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Bagaimana cara menggunakan COUNTIFS pada Excel?
=COUNTIFS(kriteria1, kriteria2, rentang_data)
=COUNTIFS(rentang_data, kriteria1, kriteria2)
=COUNTIFS(rentang_data; kriteria1; kriteria2)
=COUNTIFS(kriteria1, rentang_data, kriteria2)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Dalam COUNTIFS, fungsi LOGICAL OR digunakan untuk:
Menambahkan dua kriteria
Membandingkan dua kriteria
Menghubungkan dua kriteria
Memeriksa satu kriteria atau kriteria lainnya
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Bagaimana cara menggunakan SUMIFS pada Excel?
=SUMIFS(sum_range, criteria_range, criteria)
=SUMIFS(criteria, sum_range)
=SUMIFS(criteria_range, sum_range)
=SUMIFS(sum_range, criteria)
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Berikut adalah rumus SUMIFS yang benar untuk menghitung total penjualan pada bulan Januari:
=SUMIFS(sales_range, "January")
=SUMIFS("January", sales_range)
=SUMIFS(sales_range, month_range, "January")
=SUMIFS("January", month_range, sales_range)
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
Higher Business Management Marketing Revision
Quiz
•
KG - University
21 questions
Informatika Kelas 8
Quiz
•
8th Grade
20 questions
CPA Revision MCQ1
Quiz
•
8th - 9th Grade
20 questions
Year 8 IT - Network Communication
Quiz
•
7th - 9th Grade
20 questions
UH BERPIKIR KOMPUTASIONAL
Quiz
•
8th Grade
20 questions
soal berpikir komputasional kelas 8 gasal
Quiz
•
8th Grade - University
20 questions
Presentations Quiz
Quiz
•
6th - 12th Grade
20 questions
Excel Check Up
Quiz
•
7th - 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
