
TIK/XII/DA/UH/EXCEL
Authored by Alexy Dimz
Computers
12th Grade
Used 51+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Rumus untuk menghitung jumlah sel yang berisi angka saja adalah
COUNTA
COUNT
COUNTIF
COUNTIFS
2.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Rumus ini digunakan untuk menghitung rata-rata di excel.
SUM
MIN
AVERAGE
SUMIF
3.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
COUNTBLANK digunakan untuk...
Menghitung jumlah sel kosong
Menghitung jumlah sel berisi angka saja
Mengitung data kosong
Menghitung sel huruf saja
4.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Jika kita ingin menjumlahkan suatu data tapi dengan beberapa kriteria tertentu, maka rumus yang digunakan adalah...
COUNTIFS
SUMIF
COUNTIF
SUMIFS
5.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Untuk mengubah tulisan "ujian" menjadi "UJIAN" dalam excel, bisa menggunakan rumus...
LOWER
PROPER
UPPER
LEN
6.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Menghitung panjang karakter di excel bisa menggunakan rumus...
COUNT
TRIM
LEN
COUNTA
7.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Rumus di bawah ini yang termasuk ke dalam kategori fungsi teks adalah...
TRIM
COUNTA
MAX
AVERAGE
Access all questions and much more by creating a free account
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
Already have an account?
Similar Resources on Wayground
20 questions
INFORMATIKA
Quiz
•
12th Grade
20 questions
Soal Informatika
Quiz
•
9th - 12th Grade
15 questions
Algoritma dan Flowchart
Quiz
•
12th Grade
20 questions
Asesmen Diagnostik Algoritma dan Pemrograman Kelas 9
Quiz
•
9th Grade - University
20 questions
Latihan PSAS Kelas 9
Quiz
•
9th Grade - University
20 questions
ULA-HARIAN INFORMATIKA (SUKSES)
Quiz
•
9th - 12th Grade
20 questions
Advanced Excel
Quiz
•
KG - University
20 questions
Latihan Soal SIMKOMDIG
Quiz
•
12th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
29 questions
Alg. 1 Section 5.1 Coordinate Plane
Quiz
•
9th Grade
22 questions
fractions
Quiz
•
3rd Grade
11 questions
FOREST Effective communication
Lesson
•
KG
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
Discover more resources for Computers
20 questions
-AR -ER -IR present tense
Quiz
•
10th - 12th Grade
22 questions
El Imperfecto
Quiz
•
9th - 12th Grade
20 questions
SSS/SAS
Quiz
•
9th - 12th Grade
20 questions
verbos reflexivos en español
Quiz
•
9th - 12th Grade
14 questions
Making Inferences From Samples
Quiz
•
7th - 12th Grade
23 questions
CCG - CH8 Polygon angles and area Review
Quiz
•
9th - 12th Grade
8 questions
Momentum and Collisions
Lesson
•
9th - 12th Grade
28 questions
Ser vs estar
Quiz
•
9th - 12th Grade