UH3 BDP

UH3 BDP

KG

10 Qs

quiz-placeholder

Similar activities

CSNP-04103 - Chapter 4 - Selection

CSNP-04103 - Chapter 4 - Selection

University

10 Qs

Python if statement part 2

Python if statement part 2

University

8 Qs

Translation Exercise two

Translation Exercise two

University

10 Qs

Quiz Soal Latihan Excel

Quiz Soal Latihan Excel

KG

10 Qs

Informatika 7f

Informatika 7f

7th Grade

9 Qs

kuis utbk with @studytwtnaara

kuis utbk with @studytwtnaara

1st - 5th Grade

10 Qs

Microsoft word quiz Tabel

Microsoft word quiz Tabel

2nd Grade

10 Qs

Kesehatan

Kesehatan

Professional Development

10 Qs

UH3 BDP

UH3 BDP

Assessment

Quiz

Others

KG

Hard

Created by

Muhammad Akbar

Used 1+ times

FREE Resource

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Urutan otomatisasi vlookup setelah klik data validation adalah

Block semua nama

Ke tab data

Allow list

Input message

Error arlet

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Cara mengaktifkan chart bagan organisasi adalah

Smart art tools > Template > Active

Insert > Smart art > hierarchy

Smart art design > Text panel > paste

All arrow > Smart art > OK

Semua jawaban salah

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Rumus slip gaji untuk data gaji pokok keempatadalah ?

=VLOOKUP (Klik no. urut 4, blok sheet 1, 4, false)

=VLOOKUP (Klik no. urut 1, blok sheet 2, 4, false)

=VLOOKUP (Klik no. urut 1, blok database, 4, false)

=VLOOKUP (Klik no. urut 4, blok sheet 4, 4, true)

4.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Berikut definisi SQRT, ROUNDUP, POWER, RAND, CEILING yang sesuai adalah

Rata-rata, Bulat keatas, membesarkan,memunculkan, membulatkan

Pangkat, Bulat keatas, membesarkan,memunculkan, mengecilkan

Akar, Bulat keatas, pangkat,memunculkan, membulatkan

Memilih, Bulat keatas, membesarkan,memunculkan, mengecilkan

Semua jawaban salah

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Rumus rata-rata pada kriteria lulus adalah

=AVERAGEIF(Block sheet 1, "Lulus", Block Rata-rata)

=AVERAGEIF(Block rata-rata, "Lulus", Block status)

=AVERAGEIF(Block sheet 2, "Lulus", Block rata-rata)

=AVERAGEIF(Block status, "Lulus",Block rata-rata)

=AVERAGEIF(Block database, "Lulus",Block rata-rata)

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Rumus unutk menyusun nama sekolah otomatis yaitu

=AUTOMATIC(Klik jenis sekolah, klik nama sekolah, klik keterangan)

=CONCATENATE(Klik jenis sekolah, klik nama sekolah, klik keterangan)

=SUMIF(Klik jenis sekolah, klik nama sekolah, klik keterangan)

=CONCATENATE(Klik jenis sekolah, spasi, klik nama sekolah, spasi, klik keterangan)

=AVERAGEIF(Klik jenis sekolah, spasi, klik nama sekolah, spasi, klik keterangan)

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Rumus membulatkan kebawah yang benar adalah

=ROUND(DOWN, NUMBER, ZERO)

=ROUNDDOWN(ROUNDS A NUMBER DOWN, TOWARDS ZERO)

=ROUNDDOWN(ROUNDS TO NUMBER DOWN, TOWARDS ZERO)

=ROUND(DOWN, ROUNDS A NUMBER DOWN, TOWARDS ZERO)

Semua salah

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?

Discover more resources for Others