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
19 questions
Excel 2P-2RVW-Formulas and Functions in Excel
Quiz
•
10th - 12th Grade
20 questions
Berpikir Komputasional dan Algoritma Pemrograman
Quiz
•
12th Grade
20 questions
QUIZ TIK UH-1 SEMESTER 2
Quiz
•
12th Grade
20 questions
Fungsi IF, AND dan OR
Quiz
•
10th - 12th Grade
20 questions
1.5 Kuis Berpikir Komputasi
Quiz
•
12th Grade
20 questions
Aplikasi Pengolah Angka
Quiz
•
12th Grade - University
15 questions
Sejarah Perkembangan TIK Dan Komputer
Quiz
•
12th Grade
20 questions
quiz dasar python
Quiz
•
1st Grade - University
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
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
