Soal Pilihan Ganda Excel

Soal Pilihan Ganda Excel

Professional Development

10 Qs

quiz-placeholder

Similar activities

Chapter 2 - FSW

Chapter 2 - FSW

Professional Development

10 Qs

Post Test Struktur Kondisional dan Perulangan

Post Test Struktur Kondisional dan Perulangan

Professional Development

10 Qs

CONCEPTOS BASICOS DE EXCEL

CONCEPTOS BASICOS DE EXCEL

Professional Development

10 Qs

halo test

halo test

5th Grade - Professional Development

6 Qs

User Group Meeting 2022

User Group Meeting 2022

Professional Development

11 Qs

Test de reconocimiento

Test de reconocimiento

Professional Development

7 Qs

EXAMEN ADO V3

EXAMEN ADO V3

Professional Development

10 Qs

Arti dan Kegunaan Probabilitas

Arti dan Kegunaan Probabilitas

University - 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?