FUNGSI STATISTIKA
12th Grade
•10 Qs
Similar activities
Excel
12th Grade
•8 Qs
CIS 105 - 1.11
9th - 12th Grade
•7 Qs
Understanding Monk Traits
12th Grade
•15 Qs
Dan sigurnijeg interneta
KG - Professional Development
•11 Qs
Các thao tác cơ bản Excel 2016
12th Grade
•15 Qs
Lembar kerja Ms. Excel
12th Grade
•10 Qs
FUNGSI STATISTIKA
Quiz
•
Computers
•
12th Grade
•
Hard
Muhamad Yulianto
Used 26+ times
FREE Resource
Enhance your content
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)
Create a free account and access millions of resources
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
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
Similar Resources on Wayground
Popular Resources on Wayground
20 questions
Brand Labels
Quiz
•
5th - 12th Grade
10 questions
Ice Breaker Trivia: Food from Around the World
Quiz
•
3rd - 12th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
20 questions
ELA Advisory Review
Quiz
•
7th Grade
15 questions
Subtracting Integers
Quiz
•
7th Grade
22 questions
Adding Integers
Quiz
•
6th Grade
10 questions
Multiplication and Division Unknowns
Quiz
•
3rd Grade
10 questions
Exploring Digital Citizenship Essentials
Interactive video
•
6th - 10th Grade