Analisis Data

Analisis Data

8th Grade

•

25 Qs

quiz-placeholder

Similar activities

Mengenal Masyarakat Digital

Mengenal Masyarakat Digital

6th - 8th Grade

•

20 Qs

Excel 9A3

Excel 9A3

7th - 9th Grade

•

20 Qs

COMPUTER

COMPUTER

8th Grade

•

20 Qs

Website Basics

Website Basics

8th Grade

•

20 Qs

Kassen

Kassen

1st - 10th Grade

•

20 Qs

QUIZ NO.2 (3RD GRADING)MULTIMETER

QUIZ NO.2 (3RD GRADING)MULTIMETER

8th Grade

•

20 Qs

Basic Informatics Class 8_2

Basic Informatics Class 8_2

8th Grade

•

20 Qs

End of year quiz: Spreadsheet Modelling

End of year quiz: Spreadsheet Modelling

8th Grade

•

20 Qs

Analisis Data

Analisis Data

Assessment

Quiz

•

Computers

•

8th Grade

•

Practice Problem

•

Hard

Created by

Intan NZ

Used 7+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

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

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?