Soal Pilihan Ganda Excel

Soal Pilihan Ganda Excel

Professional Development

10 Qs

quiz-placeholder

Similar activities

Pelatihan Website Day 1

Pelatihan Website Day 1

7th Grade - Professional Development

10 Qs

Simulasi dan Komunikasi Digital

Simulasi dan Komunikasi Digital

Professional Development

10 Qs

EXCEL FUNCION SI

EXCEL FUNCION SI

Professional Development

15 Qs

EC3 - Parte 2

EC3 - Parte 2

Professional Development

12 Qs

Septimo

Septimo

KG - Professional Development

10 Qs

GUIA INF2-P1

GUIA INF2-P1

Professional Development

8 Qs

LATIHAN 1

LATIHAN 1

Professional Development

15 Qs

Quiz Ms Excel

Quiz Ms Excel

Professional Development

10 Qs

Soal Pilihan Ganda Excel

Soal Pilihan Ganda Excel

Assessment

Quiz

Computers

Professional Development

Medium

Created by

ini bossexcel

Used 3+ times

FREE Resource

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Fungsi apa yang digunakan untuk mencari nilai tertentu dalam tabel secara vertikal?

VLOOKUP

MATCH

INDEX

HLOOKUP

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Apa hasil dari formula =LEFT("Halo Dunia", 4)?

Halo

Dunia

Halu

ERROR

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Apa tujuan dari fungsi CONCATENATE?

Memisahkan teks menjadi beberapa bagian

Menggabungkan teks dari dua atau lebih sel

Membandingkan dua string teks

Menemukan substring dalam teks

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Apa hasil dari formula =TRIM(" Halo Dunia ")?

"Halo Dunia"

"HaloDunia"

" Halo Dunia "

ERROR

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Pada formula =IF(A1=10, "Sepuluh", "Bukan Sepuluh"), apa hasil jika A1 = 5?

Sepuluh

Bukan Sepuluh

TRUE

FALSE

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Apa hasil dari formula =SEARCH("D", "Halo Dunia")?

6

5

4

ERROR

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

 Jika formula =VLOOKUP(100, A1:B10, 2, FALSE) tidak menemukan nilai 100, hasilnya adalah?

0

#N/A

ERROR

100

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?