Quiz Ms Excel

Quiz Ms Excel

Assessment

Assessment

Created by

hamid abdul

Computers

Professional Development

5 plays

Hard

Student preview

quiz-placeholder

10 questions

Show answers

1.

Multiple Choice

30 sec

1 pt

Untuk Pilihan Pivot Table, terdapat pada Tab apa ?

Home Tab

Insert Tab

Formula Tab

View Tab

2.

Multiple Choice

30 sec

1 pt

Formula apakah yang digunakan untuk menghitung Nilai Rata-rata ?

=SUM()

=MIN()

=AVG()

=AVERAGE()

3.

Multiple Choice

30 sec

1 pt

Formula apa yang digunakan untuk mengambil data dari tabel lain, secara horisontal ?

=VLOOKUP()

=HLOOKUP()

=INDEX()

=MATCH()

4.

Multiple Choice

30 sec

1 pt

Formula apa yang digunakan untuk menghitung nilai maximal, minimal, penjumlahan, dan rata-rata ? (ber-urutan)

=min(), = max(), =sum(), avg()

=max(), =min(), =sum(), average()

=average(), max(), min(), =sum()

=sum(), min(), max(), average()

5.

Multiple Choice

30 sec

1 pt

Formula yang digunakan untuk mengambil sejumlah karakter dari posisi paling akhir

=Left()

=Right()

=Mid()

=Concatenate()

Explore all questions with a free account

or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?

Find a similar activity

Create activity tailored to your needs using

Quizizz AI
KUIS EXCEL

12 questions

KUIS EXCEL

assessment

Professional Development

Training Microsoft Excel 2024

10 questions

Training Microsoft Excel 2024

assessment

Professional Development

Ms Excel

12 questions

Ms Excel

assessment

Professional Development

Kuis Excel

10 questions

Kuis Excel

assessment

KG - Professional Dev...

Office Application

10 questions

Office Application

assessment

Professional Development

Latihan 3

15 questions

Latihan 3

assessment

Professional Development

BASIC EXCEL

10 questions

BASIC EXCEL

assessment

Professional Development

Pre Test Excel 7-8 Mei

10 questions

Pre Test Excel 7-8 Mei

assessment

Professional Development