Analisis Data
8th Grade
•25 Qs
Similar activities
Mengenal Masyarakat Digital
6th - 8th Grade
•20 Qs
Excel 9A3
7th - 9th Grade
•20 Qs
COMPUTER
8th Grade
•20 Qs
Website Basics
8th Grade
•20 Qs
Kassen
1st - 10th Grade
•20 Qs
QUIZ NO.2 (3RD GRADING)MULTIMETER
8th Grade
•20 Qs
Basic Informatics Class 8_2
8th Grade
•20 Qs
End of year quiz: Spreadsheet Modelling
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
Spreadsheets 1
Quiz
•
7th - 9th Grade
22 questions
VEXCode VR Unit 2 Quizizz
Quiz
•
8th Grade
20 questions
Latihan PAT Informatika Kelas 8
Quiz
•
8th Grade
20 questions
Python Functions Quiz
Quiz
•
8th Grade
20 questions
Asesmen Awal Informatika Kelas 8
Quiz
•
8th Grade
20 questions
Spreadsheet Revision
Quiz
•
7th - 9th Grade
20 questions
Spreadsheets - Lesson 3
Quiz
•
6th - 9th Grade
20 questions
Ulangan Harian (Analisis Data) Kelas 7
Quiz
•
6th - 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
