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 Wayground
10 questions
Math Asik Eksponensial

Quiz
•
9th - 12th Grade
7 questions
Simplifying Rational Exponents

Quiz
•
10th - 12th Grade
10 questions
bilangan berpangkat smk

Quiz
•
10th Grade
10 questions
Laws of Exponents - Quotient Rule

Quiz
•
9th - 11th Grade
15 questions
ಸಮಾಂತರ ಶ್ರೇಢಿಗಳು

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

Quiz
•
10th Grade - University
13 questions
TEMA 3: SUCESIONES

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

Quiz
•
8th Grade - University
Popular Resources on Wayground
25 questions
Equations of Circles

Quiz
•
10th - 11th Grade
30 questions
Week 5 Memory Builder 1 (Multiplication and Division Facts)

Quiz
•
9th Grade
33 questions
Unit 3 Summative - Summer School: Immune System

Quiz
•
10th Grade
10 questions
Writing and Identifying Ratios Practice

Quiz
•
5th - 6th Grade
36 questions
Prime and Composite Numbers

Quiz
•
5th Grade
14 questions
Exterior and Interior angles of Polygons

Quiz
•
8th Grade
37 questions
Camp Re-cap Week 1 (no regression)

Quiz
•
9th - 12th Grade
46 questions
Biology Semester 1 Review

Quiz
•
10th Grade