
Quiz Excel Dasar
Authored by Peserta 07617
Information Technology (IT)
10th Grade

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Ketika kamu mengetik rumus =SUM(A2:A10) namun hasilnya 0, kemungkinan terbesar penyebabnya adalah:
Format sel bukan angka
Excel belum diaktifkan
Judul tabel terlalu panjang
Komputer tidak terkoneksi internet
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Dalam sebuah tabel Excel, hasil panen sayur ditulis di kolom B, dan harga jual di kolom C. Rumus yang paling tepat untuk mencari pendapatan adalah:
=SUM(B2:C2)
=B2-C2
=B2*C2
=AVERAGE(B2,C2)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Mengapa menggunakan tabel Excel dengan filter akan mempermudah analisis data hasil panen?
Bisa melihat data sesuai kriteria tertentu
Menyembunyikan semua data
Menghitung otomatis semua sel
Menghapus data dengan cepat
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi IF di Excel paling tepat digunakan untuk:
Menghitung total
Menentukan hasil panen tinggi atau rendah berdasarkan jumlah
Menjumlahkan angka ganjil
Mengurutkan nama petani
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Seorang siswa menggunakan grafik lingkaran untuk membandingkan hasil panen tiap bulan. Apa kekurangan grafik ini?
Tidak bisa diberi warna
Tidak cocok untuk data yang terus berubah
Terlalu banyak rumus
Butuh koneksi internet
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Apa alasan terbaik memilih fungsi AVERAGEIF daripada AVERAGE biasa?
Lebih cepat dijalankan
Bisa menghitung rata-rata sesuai kriteria tertentu
Menambah jumlah baris
Tidak butuh tanda sama dengan (=)
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Jika dalam Excel data jumlah panen per bulan ditampilkan sebagai grafik garis, namun tidak terlihat tren yang jelas, apa yang bisa ditambahkan untuk memperjelas?
Tabel baru
Garis tren (trendline)
Warna latar
Foto tanaman
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
12 questions
Quiz_Perteknologian
Quiz
•
10th Grade
15 questions
Profesi Utama di Bidang Informatika
Quiz
•
10th Grade - University
10 questions
Pengenalan Perangkat Lunak Kelas 7
Quiz
•
7th Grade - University
9 questions
JARINGAN KOMPUTER DAN INTERNET
Quiz
•
10th Grade - University
15 questions
G4-Microprocessors and Their Uses
Quiz
•
4th Grade - University
10 questions
EVALUASI STRUKTUR DATA
Quiz
•
10th Grade
10 questions
Kabel Jaringan dan Fungsinya
Quiz
•
10th Grade - University
15 questions
Soal HTML
Quiz
•
10th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
10 questions
Probability Practice
Quiz
•
4th Grade
15 questions
Probability on Number LIne
Quiz
•
4th Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
6 questions
Appropriate Chromebook Usage
Lesson
•
7th Grade
10 questions
Greek Bases tele and phon
Quiz
•
6th - 8th Grade
Discover more resources for Information Technology (IT)
15 questions
Making Inferences
Quiz
•
7th - 12th Grade
23 questions
TSI Math Vocabulary
Quiz
•
10th - 12th Grade
20 questions
-AR -ER -IR present tense
Quiz
•
10th - 12th Grade
10 questions
Cell Organelles and Their Functions
Interactive video
•
6th - 10th Grade
10 questions
Plotting Points on a Coordinate Plane: Quadrant 1 Essentials
Interactive video
•
6th - 10th Grade
10 questions
Exploring Abiotic and Biotic Factors in Ecosystems
Interactive video
•
6th - 10th Grade
20 questions
SSS/SAS
Quiz
•
9th - 12th Grade
20 questions
Figurative Language Review
Quiz
•
10th Grade