Untuk mencari rata-rata dari A3, A4, A5, A6, dan A7 pada sel A8 dapat dilakukan dengan cara...
Fungsi Statistika dalam Excel

Quiz
•
Mathematics
•
10th Grade
•
Medium
Nia Kurnia Musri
Used 12+ times
FREE Resource
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
=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 Quizizz
13 questions
Lesson 10-2 (Part 2): Area of Regular Polygons

Quiz
•
9th - 11th Grade
10 questions
bilangan berpangkat smk

Quiz
•
10th Grade
10 questions
ลำดับและอนุกรม (ลำดับ)-ONET

Quiz
•
10th Grade - University
13 questions
Hatványozás azonosságai

Quiz
•
8th - 12th Grade
13 questions
Indices Warm Up

Quiz
•
6th Grade - University
15 questions
Simple Exponent Laws

Quiz
•
8th - 10th Grade
14 questions
Multiplication Laws of Exponents

Quiz
•
8th Grade - University
10 questions
Potències 1

Quiz
•
8th - 10th Grade
Popular Resources on Quizizz
15 questions
Multiplication Facts

Quiz
•
4th Grade
25 questions
SS Combined Advisory Quiz

Quiz
•
6th - 8th Grade
40 questions
Week 4 Student In Class Practice Set

Quiz
•
9th - 12th Grade
40 questions
SOL: ILE DNA Tech, Gen, Evol 2025

Quiz
•
9th - 12th Grade
20 questions
NC Universities (R2H)

Quiz
•
9th - 12th Grade
15 questions
June Review Quiz

Quiz
•
Professional Development
20 questions
Congruent and Similar Triangles

Quiz
•
8th Grade
25 questions
Triangle Inequalities

Quiz
•
10th - 12th Grade