Fungsi Statistika dalam Excel
Quiz
•
Mathematics
•
10th Grade
•
Medium
Nia Kurnia Musri
Used 13+ times
FREE Resource
Enhance your content
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Untuk mencari rata-rata dari A3, A4, A5, A6, dan A7 pada sel A8 dapat dilakukan dengan cara...
=max(A3:A7)
=Average(A3:A7)
=Average(A3:A8)
=Average(A3-A7)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Untuk menentukan nilai terendah dari deret range D10 sampai D20 dengan menuliskan fungsi...
=max(D10:D20)
=sum(D10:D20)
=min(D10:D20)
=count(D10:D20)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Berikut ini yang bukan perintah-perintah yang termasuk fungsi statistik adalah...
Dmin
Dmax
Dcount
Median
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi statistik yang digunakan untuk menghitung data yang berisi angka dan huruf adalah...
Countblank
Count
Counta
Countif
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Jika pada C8 = 10, C9 = 12, C10 = 45, C11 = 0, C12= Baik, C13= Cukup, maka jika menggunakan fungsi Count maka hasil yang diperoleh adalah...
6
5
4
3
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi statistik yang digunakan untuk menghitung data yang berisi angka dan huruf adalah...
Countblank
Count
Counta
Countif
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Jika pada C8 = 10, C9 = 12, C10 = 45, C11 = 0, C12= Baik, C13= Cukup, maka jika menggunakan fungsi Count maka hasil yang diperoleh adalah...
6
5
4
3
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
10 questions
Geometric series
Quiz
•
10th Grade
10 questions
RASIO TRIGONOMETRI PADA SEGITIGA SIKU-SIKU
Quiz
•
10th Grade
10 questions
PRE-TEST TURUNAN TRIGONOMETRI
Quiz
•
10th Grade
15 questions
Monomi e Polinomi
Quiz
•
10th Grade
12 questions
EXCEL
Quiz
•
7th Grade - University
15 questions
Fungsi dan persamaan kuadratik ting 4
Quiz
•
10th Grade
15 questions
Ley del Seno y coseno
Quiz
•
10th - 12th Grade
10 questions
Formative Assessment 1 [Arithmetic Sequence]
Quiz
•
10th Grade
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
Discover more resources for Mathematics
29 questions
CCG 2.2.3 Area
Quiz
•
9th - 12th Grade
10 questions
SAT Focus: Geometry
Quiz
•
10th Grade
20 questions
Solving Multi-Step Equations
Quiz
•
10th Grade
10 questions
Decoding New Vocabulary Through Context Clues
Interactive video
•
6th - 10th Grade
9 questions
Geometry and Trigonometry Concepts
Interactive video
•
9th - 12th Grade
17 questions
Parallel lines cut by a transversal
Quiz
•
10th Grade
20 questions
Conditional Statements
Quiz
•
10th Grade
17 questions
Analyze Real-World Inequalities and Graphs
Quiz
•
9th - 12th Grade