Fungsi apa yang digunakan untuk menghitung jumlah nilai dalam suatu range di Excel?
Analisi Data Menggunakan Excell
7th Grade
•20 Qs
Similar activities
Latihan Microsoft Word untuk Kelas 7 dan 8
7th Grade
•15 Qs
Quiz Data dan Perangkat Lunak
7th Grade - University
•25 Qs
Informatika TIK
7th Grade
•20 Qs
PTS Informatika Kelas 7
7th Grade
•15 Qs
Software
7th Grade
•15 Qs
Ulangan Harian Informatika (Bab 1 & 2)
7th Grade
•24 Qs
Kuis Analisis Data Tentang Ms. Excel Dasar
7th Grade
•20 Qs
BAB 6 ANALISIS DATA B. Perkakas Pengolah Lembar Kerja
7th Grade - University
•20 Qs
Analisi Data Menggunakan Excell
Quiz
•
Information Technology (IT)
•
7th Grade
•
Medium
Susilawati Susilawati
Used 2+ times
FREE Resource
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
SUM
AVERAGE
COUNT
MAX
2.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
Jika ingin mencari nilai rata-rata dari sekumpulan data dalam Excel, kita dapat menggunakan fungsi …
SUM
COUNT
MAX
AVERAGE
3.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
Fitur di Excel yang digunakan untuk menyaring data berdasarkan kriteria tertentu disebut …
Sort
Group
Pivot
Filter
4.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
Manakah fungsi yang digunakan untuk menghitung jumlah sel yang berisi angka dalam suatu range?
MAX
COUNT
AVERAGE
SUM
5.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
Untuk mencari nilai tertinggi dalam sekumpulan data, fungsi yang digunakan adalah …
min
average
sum
max
6.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
Jika ingin menghitung jumlah sel yang memenuhi syarat tertentu, fungsi yang digunakan adalah …
SUMIF
AVERAGEIF
COUNTIF
MAXIF
7.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
Fungsi yang digunakan untuk menjumlahkan angka berdasarkan suatu kondisi tertentu adalah …
ADDIF
SUMIF
TOTALIF
SUM
Create a free account and access millions of resources
Create resources
Host any resource
Get auto-graded reports
Microsoft
Apple
Others
Similar Resources on Quizizz
20 questions
G7 STS 2 Informatika
Quiz
•
7th Grade
15 questions
Asesmen Harian Informatika Kelas 7
Quiz
•
7th Grade
25 questions
KUIS TIK KELAS 7
Quiz
•
7th Grade - University
20 questions
sumatif 1 kelas 8 semester 2
Quiz
•
7th Grade
20 questions
Remidial Informatika SMP
Quiz
•
7th Grade
20 questions
SISTEM KOMPUTER
Quiz
•
7th Grade
20 questions
ULANGAN ANALISIS DATA SEMESTER 2 KELAS 7
Quiz
•
7th Grade
20 questions
TIK-Pengolahan Data 1
Quiz
•
7th Grade
Popular Resources on Quizizz
15 questions
Character Analysis
Quiz
•
4th Grade
17 questions
Chapter 12 - Doing the Right Thing
Quiz
•
9th - 12th Grade
10 questions
American Flag
Quiz
•
1st - 2nd Grade
20 questions
Reading Comprehension
Quiz
•
5th Grade
30 questions
Linear Inequalities
Quiz
•
9th - 12th Grade
20 questions
Types of Credit
Quiz
•
9th - 12th Grade
18 questions
Full S.T.E.A.M. Ahead Summer Academy Pre-Test 24-25
Quiz
•
5th Grade
14 questions
Misplaced and Dangling Modifiers
Quiz
•
6th - 8th Grade
Discover more resources for Information Technology (IT)
14 questions
Misplaced and Dangling Modifiers
Quiz
•
6th - 8th Grade
17 questions
Parts of Speech
Quiz
•
7th - 12th Grade
11 questions
Decimal/fraction conversions quick check
Quiz
•
5th - 7th Grade
10 questions
Identifying equations
Quiz
•
KG - University
44 questions
El fin del año- 7th
Quiz
•
7th - 12th Grade
20 questions
Math Review
Quiz
•
7th Grade
14 questions
Subtracting Integers
Lesson
•
6th - 8th Grade
15 questions
Exponent Properties
Quiz
•
7th - 9th Grade