FUNGSI STATISTIKA
Authored by Muhamad Yulianto
Computers
12th Grade
Used 28+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
5 sec • 1 pt
FUNGSI UNTUK MENJUMLAHKAN ANGKA PADA SEL ATAU RANGE
MAX
MIN
SUM
AVERAGE
2.
MULTIPLE CHOICE QUESTION
5 sec • 1 pt
=AVERAGE ( 1,2,3,4,5)
MENCARI RATA NILAI DARI 1 SAMPAI 5
2
3
7
3.
MULTIPLE CHOICE QUESTION
5 sec • 1 pt
MENGHITUNG BANYAKNYA ANGKA DARI RANGE A1 SAMPAI B5
=COUNTIF(A1:B5)
=COUNTA(A1:B5)
=COUNT(A1:B5)
=COUNTIF(A1;B5)
4.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
TENTUKAN RUMUS UNTUK MENCARI RATA - RATA
AVERAGE(D6:H6)
=AVERAGE(D6;H6)
=RATA-RATA(D6:H6)
=AVERAGE(D6:H6)
5.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
A,B,C,D,E,A,F,C,A,A,A,B,C,C,C,C,C,C,D,C,D
BERDASARKAN DATA DI ATAS, TENTUKAN FORMULA UNTUK MENCARI BERAPAKALI HURUF C MUNCUL?
=COUNTA(DATA,"C")
=COUNTIF(DATA,"C")
=COUNT(DATA,"C")
=COUNTIF(C,"C")
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
FORMULA NILAI AKHIR RACHMAN DENGAN DIDAPAT DENGAN KETENTUAN
NILAI AKHIR = 20% TOTAL ULANGAN + 40% EVALUASI
ADALAH ...
=20%*(E11+F12+G12)+40%*H12
=20%*(E12+F12+G12)+40*H12
=20*(E12+F12+G12)+40%*H12
=20%*(E12+F12+G12)+40%*H12
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
FORMULA UNTUK MENGHITUNG BANYAK NYA SISWA PEREMPUAN ADALAH ...
=COUNTIF(D6:D12;"P")
=COUNT(D6:D12;"P")
=COUNTA(D6:D12;"P")
=COUNTIF(D6:D12)
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?
