SOAL RUMUS DASAR EXCEL
Authored by BINTANG MANGENGKE
Science
10th Grade
Used 1+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
13 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Apa rumus Excel untuk menjumlahkan nilai di seluruh sel dalam rentang tertentu?
=SUM(A1:A5)
=SUM(range)
=SUM(A1:A10)
=SUM(A1:A20)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Bagaimana cara menghitung rata-rata dari sekelompok angka di Excel?
=SUM(A1:A10)/10
=AVERAGE(A1:A10)
=(SUM(A1:A10))/COUNT(A1:A10)
=MEDIAN(A1:A10)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Apa fungsi Excel untuk menemukan nilai maksimum dalam rentang sel tertentu?
Menggunakan fungsi MIN dalam Excel.
Menggunakan rumus AVERAGE dalam Excel.
Menggunakan fungsi MAX dalam Excel.
Menggunakan fungsi SUM dalam Excel.
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Rumus Excel apa yang digunakan untuk mencari nilai minimum dalam rentang sel?
AVERAGE
SUM
MIN
MAX
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Bagaimana cara menghitung jumlah sel non-kosong dalam Excel?
Pilih seluruh sel di lembar kerja, lalu gunakan fungsi SUM
Hitung jumlah sel kosong di lembar kerja
Pilih seluruh sel di lembar kerja, lalu gunakan fungsi COUNTA.
Gunakan fungsi AVERAGE untuk menghitung jumlah sel non-kosong
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Apa fungsi Excel yang digunakan untuk menetapkan kondisi tertentu pada sel?
AND
OR
SUM
IF
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Bagaimana cara menggunakan fungsi IF dalam Excel untuk menampilkan nilai tertentu jika kondisi terpenuhi?
Gunakan fungsi IF dengan sintaks: =IF(logical_test, value_if_true, value_if_false, value_if_false)
IF(logical_test, value_if_true, value_if_false)
IF(logical_test, value_if_true)
Gunakan fungsi IF dengan sintaks: =IF(logical_test, value_if_true, value_if_false)
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
17 questions
PEMBAHAGIAN SEL
Quiz
•
10th Grade
10 questions
Sifat-sifat Bunyi dan Indera Pendengaran
Quiz
•
7th - 10th Grade
17 questions
friction and inclined planes, review
Quiz
•
9th - 12th Grade
10 questions
6.3 Sokongan, Pertumbuhan dan Kestabilan dalam Tumbuhan
Quiz
•
10th - 12th Grade
15 questions
gambar teknik kelas X TKR 3
Quiz
•
10th Grade
15 questions
TN Ready Science Review
Quiz
•
6th Grade - University
16 questions
Biologi X
Quiz
•
10th Grade
15 questions
Uji Pengetahuan Organ Sistem Pernapasan
Quiz
•
8th Grade - University
Popular Resources on Wayground
7 questions
History of Valentine's Day
Interactive video
•
4th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
15 questions
Valentine's Day Trivia
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
Discover more resources for Science
10 questions
Exploring Weathering, Erosion, and Deposition Processes
Interactive video
•
6th - 10th Grade
10 questions
Exploring Mendelian Genetics and Punnett Squares
Interactive video
•
6th - 10th Grade
10 questions
Exploring Light and Waves Concepts
Interactive video
•
6th - 10th Grade
35 questions
DNA Structure and Replication
Quiz
•
10th Grade
10 questions
Distinguishing Natural Hazards from Disasters
Interactive video
•
6th - 10th Grade
89 questions
Unit 1 (Ch 2 & 3) Test Review - Water/Ocean Currents
Quiz
•
9th - 12th Grade
48 questions
Review for Homeostasis & Interacting Systems Test
Quiz
•
9th - 12th Grade
10 questions
Exploring Protein Synthesis: Transcription and Translation
Interactive video
•
10th Grade