FUNGSI STATISTIKA
12th Grade
•10 Qs
Similar activities
PTI QUIZ 2
2nd Grade - University
•10 Qs
Microsoft Excel
12th Grade
•15 Qs
Microsoft Excel
12th Grade
•10 Qs
Excel
1st - 12th Grade
•10 Qs
SHORTCUT PADA KEYBOARD
10th - 12th Grade
•10 Qs
KUIS TKJ
12th Grade
•15 Qs
ÔN TẬP CUỐI KỲ 2 - TIN HỌC 9
9th Grade - University
•15 Qs
Unit 5 Data Modelling
11th - 12th Grade
•10 Qs
FUNGSI STATISTIKA
Quiz
•
Computers
•
12th Grade
•
Practice Problem
•
Hard
Muhamad Yulianto
Used 28+ times
FREE Resource
Enhance your content in a minute
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
Already have an account?
Similar Resources on Wayground
10 questions
Lab Ms Excel
Quiz
•
12th Grade
10 questions
soal Pretest analisis data
Quiz
•
9th - 12th Grade
10 questions
INFORMATIKA
Quiz
•
1st - 12th Grade
15 questions
ASK TINGKATAN 1
Quiz
•
7th - 12th Grade
15 questions
Google Spreadsheet
Quiz
•
9th - 12th Grade
10 questions
Относительные, абсолютные, смешанные ссылки
Quiz
•
9th - 12th Grade
15 questions
Data Representation
Quiz
•
12th Grade
10 questions
2223_S4_ICT_T2_exam_exercise_1-10
Quiz
•
9th - 12th Grade
Popular Resources on Wayground
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
4:3 Model Multiplication of Decimals by Whole Numbers
Quiz
•
5th Grade
10 questions
The Best Christmas Pageant Ever Chapters 1 & 2
Quiz
•
4th Grade
12 questions
Unit 4 Review Day
Quiz
•
3rd Grade
20 questions
Christmas Trivia
Quiz
•
6th - 8th Grade
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade
14 questions
Christmas Trivia
Quiz
•
5th Grade
15 questions
Solving Equations with Variables on Both Sides Review
Quiz
•
8th Grade