Search Header Logo

fungsi logika

Authored by Sobirin Sobirin

Computers, Other

7th Grade

Used 5+ times

fungsi logika
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

20 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

45 sec • 5 pts

Fungsi logika pada Excel adalah

IF

IFS

SUM

Count

2.

MULTIPLE CHOICE QUESTION

45 sec • 5 pts

Jika C1 adalah atau lebih dari 9 maka tulis "Baik" jika tidak tulis "kurang"

Penulisaan fungsi yang benar adalah ...

=IF(C1>=9,"BAIK","KURANG")

=IF(C1=9,"BAIK","KURANG")

=IF(C1<,"BAIK","KURANG")

=IF(C1=1,BAIK, KURANG)

3.

MULTIPLE CHOICE QUESTION

45 sec • 5 pts

Operator yang digunakan untuk perbandingan adalah...

-

+

/

=

4.

MULTIPLE CHOICE QUESTION

45 sec • 5 pts

Hasil dari fungsi berikut badalah

= IF(24>30,23,29)

24

30

23

29

5.

MULTIPLE CHOICE QUESTION

45 sec • 5 pts

Sintak fungsi IF adalah ...

=IF(Pernyataan)

=IF(Pernyataan,”Jawaban”)

=IF(Pernyataan,”Pilihan Jawaban”)

=IF(Pernyataan,”Pilihan Jawaban Benar”,”Pilihan Jawaban Salah”)

=IF(Pernyataan,”Jawaban Benar”,”Jawaban Salah",0)

6.

MULTIPLE CHOICE QUESTION

45 sec • 5 pts

Penulisan perintah logika berikut ini yang benar adalah …

=IF(A5>5)5,A1=200

=IF(A1>5,A1)=”LULUS”,B1=”TIDAK”

=IF(A1>5,”SARJANA”,”SMA”)

=IF(A1>5)=”LULUS”,B1=”TIDAK”

=IF(A1>5,A1*B1,A1…B1)

7.

MULTIPLE CHOICE QUESTION

45 sec • 5 pts

Penulisan rumus berikut ini benar, kecuali ...

=IF(A1,B1,"Benar","Salah)

=IF(A1=B1,"Benar","Salah)

=IF(A1<B1,"Benar","Salah)

=IF(A1=100,"Benar","Salah)

=IF(B1=100,"Benar","Salah)

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?