Analisis Data
8th Grade
•25 Qs
Similar activities
Spreadsheet
8th Grade - University
•20 Qs
MS Excel Grade 6
6th - 10th Grade
•20 Qs
Spreadsheet Key Terms
6th - 8th Grade
•20 Qs
Review Materi Ms. Excel
6th - 8th Grade
•20 Qs
Algoritma ASK F2, CIKGU AKHYAR
8th Grade
•20 Qs
Robotics
7th - 8th Grade
•20 Qs
ptscod
8th Grade
•20 Qs
Pengayaan TIK 13-12-2021 kelas 8
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
Ms. Excel Dasar 1
Quiz
•
8th Grade
24 questions
Spreadsheets Pre-Quiz
Quiz
•
7th - 9th Grade
20 questions
CompTIA IT Fundamentals Review (2nd Attempt)
Quiz
•
7th - 8th Grade
21 questions
Синтаксис Python
Quiz
•
7th - 11th Grade
21 questions
Struktur kawalan ulangan
Quiz
•
1st - 12th Grade
20 questions
BERPIKIR KOMPUTASIONAL 10.12
Quiz
•
1st Grade - University
20 questions
Excel 2016
Quiz
•
6th Grade - Professio...
20 questions
pengenalan jendela pengolah angka
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
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
