Quiz Ms Excel

Assessment
•

hamid abdul
•
Computers
•
Professional Development
•
5 plays
•
Hard
Student preview

10 questions
Show answers
1.
Multiple Choice
Untuk Pilihan Pivot Table, terdapat pada Tab apa ?
Home Tab
Insert Tab
Formula Tab
View Tab
2.
Multiple Choice
Formula apakah yang digunakan untuk menghitung Nilai Rata-rata ?
=SUM()
=MIN()
=AVG()
=AVERAGE()
3.
Multiple Choice
Formula apa yang digunakan untuk mengambil data dari tabel lain, secara horisontal ?
=VLOOKUP()
=HLOOKUP()
=INDEX()
=MATCH()
4.
Multiple Choice
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
Formula yang digunakan untuk mengambil sejumlah karakter dari posisi paling akhir
=Left()
=Right()
=Mid()
=Concatenate()
Explore all questions with a free account
Find a similar activity
Create activity tailored to your needs using
Training Microsoft Excel 2024

•
Professional Development
Ms Excel

•
Professional Development
Kuis Excel

•
KG - Professional Dev...
Office Application

•
Professional Development
Latihan 3

•
Professional Development
BASIC EXCEL

•
Professional Development
Pre Test Excel 7-8 Mei

•
Professional Development
KUIS EXCEL

•
Professional Development