
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
18 questions
IF9 Basic Excel Formula
Quiz
•
9th - 12th Grade
10 questions
Asesmen Awal Pengolah Data Dasar
Quiz
•
7th Grade - University
20 questions
Sumatif Analisis Data Informatika Kelas 7
Quiz
•
9th - 12th Grade
20 questions
Dasar Komputer
Quiz
•
10th Grade - University
20 questions
LOOKUP
Quiz
•
9th Grade - University
20 questions
Soal TIK Tema Microsoft Office
Quiz
•
6th Grade - University
10 questions
Fungsi Absolut dan Semi Absolut pada Aplikasi Spreadsheet
Quiz
•
11th Grade
20 questions
Kuis Word dan Excel
Quiz
•
11th Grade
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