
Diagnostik Test - ICT 11
Quiz
•
Computers
•
11th Grade
•
Medium

LRC NFBS Bogor
Used 2+ times
FREE Resource
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Apa fungsi dari "Freeze" di Google Spreadsheet?
Membekukan dokumen agar tidak bisa diedit.
Mengunci baris atau kolom agar tetap terlihat saat menggulir.
Membekukan data agar tidak berubah.
Menyimpan dokumen secara otomatis.
2.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
Untuk menggabungkan teks dari dua sel, fungsi yang digunakan adalah...
CONCAT
SUM
CONCATENATE
SPLIT
3.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Shortcut keyboard Ctrl + / di Google Spreadsheet digunakan untuk...
Menyisipkan komentar.
Membuka daftar pintasan keyboard.
Membagi data dalam sel.
Memformat sel.
4.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Apa hasil dari formula berikut? =ARRAYFORMULA(A1:A3 * B1:B3)
Mengalikan semua nilai dalam kolom A1 hingga A3 dengan B1 hingga B3.
Menggabungkan nilai kolom A dan B.
Menghitung rata-rata nilai dalam kolom A dan B.
Tidak ada hasil.
5.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Jika Anda ingin menghapus nilai duplikat dalam suatu kolom, menu apa yang harus digunakan?
Data > Data Validation
Data > Remove Duplicates
Tools > Cleanup Suggestions
Edit > Clear
6.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Apa tujuan formula ini?
=LEN(A1) - LEN(SUBSTITUTE(A1, " ", "")) + 1
Menghitung jumlah huruf.
Menghitung jumlah kata.
Menghitung jumlah angka.
Menghitung jumlah spasi.
7.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Fitur apa yang digunakan untuk mengubah data menjadi visual seperti grafik?
Explore
Chart
Pivot Table
Filter View
Create a free account and access millions of resources
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
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
Similar Resources on Wayground
13 questions
MENGENAL SPREADSHEET
Quiz
•
9th - 12th Grade
20 questions
ULANGAN HARIAN-2 INFORMATIKA ARRAY
Quiz
•
11th Grade
20 questions
Pemahaman Microsoft Office untuk Siswa
Quiz
•
10th Grade - University
15 questions
Basis Data XI
Quiz
•
11th Grade
20 questions
Quiz kelas 4
Quiz
•
1st Grade - University
20 questions
Quiz Microsoft Excel: Sort and Filter
Quiz
•
5th Grade - University
20 questions
Uji Pemahaman Rekursi
Quiz
•
11th Grade
20 questions
soal tik tema microsoft Office
Quiz
•
6th Grade - University
Popular Resources on Wayground
20 questions
Brand Labels
Quiz
•
5th - 12th Grade
10 questions
Ice Breaker Trivia: Food from Around the World
Quiz
•
3rd - 12th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
20 questions
ELA Advisory Review
Quiz
•
7th Grade
15 questions
Subtracting Integers
Quiz
•
7th Grade
22 questions
Adding Integers
Quiz
•
6th Grade
10 questions
Multiplication and Division Unknowns
Quiz
•
3rd Grade
10 questions
Exploring Digital Citizenship Essentials
Interactive video
•
6th - 10th Grade