Fungsi Statistika dalam Excel

Quiz
•
Mathematics
•
10th Grade
•
Medium
Nia Kurnia Musri
Used 13+ times
FREE Resource
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
Similar Resources on Wayground
13 questions
Exponent Rules Laws of Exponents

Quiz
•
8th Grade - University
10 questions
Matematika (Peminatan) Kelas X

Quiz
•
10th Grade
10 questions
Exponentes

Quiz
•
10th Grade
14 questions
Expand With Exponents

Quiz
•
8th Grade - University
11 questions
Law of Exponents Multiply and Divide

Quiz
•
8th Grade - University
15 questions
Laws of Exponents Open Ended

Quiz
•
8th Grade - University
10 questions
All the Exponent Rules

Quiz
•
8th Grade - University
9 questions
Rewrite Expression Using Exponents

Quiz
•
8th Grade - University
Popular Resources on Wayground
10 questions
Video Games

Quiz
•
6th - 12th Grade
10 questions
Lab Safety Procedures and Guidelines

Interactive video
•
6th - 10th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
10 questions
UPDATED FOREST Kindness 9-22

Lesson
•
9th - 12th Grade
22 questions
Adding Integers

Quiz
•
6th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
20 questions
US Constitution Quiz

Quiz
•
11th Grade
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade
Discover more resources for Mathematics
15 questions
ACT Math Practice Test

Quiz
•
9th - 12th Grade
16 questions
Parallel Lines Cut by a Transversal

Lesson
•
9th - 10th Grade
16 questions
Parallel Lines cut by a Transversal

Quiz
•
10th Grade
20 questions
Solving Multi-Step Equations

Quiz
•
10th Grade
20 questions
Multi-Step Equations and Variables on Both Sides

Quiz
•
9th - 12th Grade
10 questions
Angle Relationships with Parallel Lines and a Transversal

Quiz
•
9th - 12th Grade
10 questions
Angle Addition Postulate

Quiz
•
10th Grade
20 questions
Translations, Reflections & Rotations

Quiz
•
8th - 10th Grade