Fungsi Dasar Excel untuk Pelajar
Authored by Wayground Content
Computers
5th Grade
Used 47+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
5 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
MIN
Nilai terbesar. Contoh: =MAX(C1:C10)
Nilai terkecil. Contoh: =MIN(C1:C10)
Nilai rata-rata. Contoh: =AVERAGE(C1:C10)
Nilai total. Contoh: =SUM(C1:C10)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
AVERAGE
Rata-rata angka. Contoh: =AVERAGE(B1:B10)
Jumlah total angka. Contoh: =SUM(B1:B10)
Nilai maksimum dari angka. Contoh: =MAX(B1:B10)
Nilai minimum dari angka. Contoh: =MIN(B1:B10)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
COUNT
Menghitung sel berisi angka. Contoh: =COUNT(E1:E10)
Menghitung jumlah sel kosong. Contoh: =COUNTA(E1:E10)
Menghitung rata-rata sel. Contoh: =AVERAGE(E1:E10)
Menghitung sel berisi teks. Contoh: =COUNTIF(E1:E10, "*text*")
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
MAX
Nilai terkecil. Contoh: =MIN(D1:D10)
Nilai terbesar. Contoh: =MAX(D1:D10)
Rata-rata dari nilai. Contoh: =AVERAGE(D1:D10)
Jumlah total dari nilai. Contoh: =SUM(D1:D10)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
SUM
Menjumlahkan angka. Contoh: =SUM(A1:A5)
Mengalikan angka. Contoh: =PRODUCT(A1:A5)
Mengurangi angka. Contoh: =SUBTRACT(A1:A5)
Membagi angka. Contoh: =DIVIDE(A1:A5)
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
