Search Header Logo

D-7 Post Test STIKES

Authored by Uum Zakaria

Science

1st Grade

Used 1+ times

D-7 Post Test STIKES
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Anda ingin memberi skor ‘A’, ‘B’, ‘C’, atau ‘D’ berdasarkan nilai. Fungsi yang digunakan adalah...

VLOOKUP

OR

Nested IF dengan rentang nilai

SUMIFS

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Jika ingin validasi sel yang hanya bisa diisi saat kolom lain berisi ‘Aktif’, gunakan...

COUNTIF

Data Validation + Custom formula =IF(B2="Aktif",TRUE,FALSE)

LEFT

HLOOKUP

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Ingin membuat drop-down dinamis: pilihan kabupaten berubah sesuai provinsi. Cara terbaik?

Slicer

Data Validation + INDIRECT dari Named Range

Manual

Format Table

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Nested IF sangat panjang dan sulit dibaca. Alternatif terbaik adalah...

OR

LEN

IFS() function (Excel 2016 ke atas)

MATCH

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Anda ingin memberi peringatan input jika sel kosong, tapi tetap mengizinkan isi kosong jika bukan hari kerja. Solusi?

Hyperlink

Data Validation + IF(WORKDAY(TODAY(),0), formula logika)

LEFT

COUNT

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Fungsi untuk menampilkan “VALID” jika usia di antara 20 dan 60 tahun?

=IF(OR(A1<20,A1>60),"VALID","")

=IF(AND(A1>=20,A1<=60), "VALID", "TIDAK VALID")

=IF(A1=20:60)

=IF(A1<=20 AND >=60)

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Ingin memeriksa kolom ‘A’ apakah kosong, dan jika iya hasil “Wajib Diisi”. Gunakan...

=ISBLANK(A1)

=IF(A1="", "Wajib Diisi", "OK")

=A1<>""

=AND(A1)

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?