belajar excel
Authored by Agus Suswala
Special Education
10th Grade
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
21 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Seorang pemilik toko roti ingin menghitung total biaya produksi roti manis menggunakan Excel. Data tersimpan di kolom A (jumlah unit) dan kolom B (biaya per unit). Rumus Excel apa yang digunakan untuk menghitung total biaya di sel C1?
=A1+B1
=A1*B1
=SUM(A1:B1)
=A1/B1
=AVERAGE(A1:B1)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Dalam spreadsheet Excel, data penjualan roti manis tersimpan di sel B2:B10. Rumus apa yang digunakan untuk menghitung total penjualan?
=SUM(B2:B10)
=COUNT(B2:B10)
=AVERAGE(B2:B10)
=MAX(B2:B10)
=MIN(B2:B10)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Toko roti mencatat harga jual roti manis di sel A1 (Rp10.000) dan jumlah terjual di sel B1 (500 unit). Rumus apa yang digunakan untuk menghitung pendapatan di sel C1?
=A1+B1
=A1*B1
=A1/B1
=SUM(A1:B1)
=A1-B1
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Pemilik toko roti ingin mengetahui rata-rata biaya produksi roti manis per hari selama seminggu (data di sel C2:C8). Rumus Excel apa yang tepat?
=SUM(C2:C8)
=AVERAGE(C2:C8)
=COUNT(C2:C8)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Data stok roti manis di sel D1 adalah 300 unit. Pemilik ingin memeriksa apakah stok cukup untuk pesanan 350 unit di sel E1. Rumus apa yang digunakan untuk menampilkan "Cukup" jika stok lebih besar, dan "Kurang" jika sebaliknya?
=IF(D1>E1, "Cukup", "Kurang")
=IF(D1
=IF(D1=E1, "Cukup", "Kurang")
=IF(D1>=E1, "Kurang", "Cukup")
=IF(D1<=E1, "Cukup", "Kurang")
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Toko roti mencatat penjualan harian di sel B2:B31. Rumus apa yang digunakan untuk menghitung jumlah hari dengan penjualan di atas 100 unit?
=COUNT(B2:B31)
=COUNTIF(B2:B31, ">100")
=SUMIF(B2:B31, ">100")
=AVERAGEIF(B2:B31, ">100")
=MAX(B2:B31)
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Pemilik toko roti ingin memberikan diskon 10% untuk harga jual Rp10.000 (sel A1) jika penjualan melebihi 500 unit (sel B1). Rumus apa yang digunakan untuk menghitung harga setelah diskon?
=IF(B1>500, A1*0.9, A1)
=IF(B1<500, A1*0.9, A1)
=IF(B1>500, A1*1.0, A1)
=IF(B1>=500, A1*1.1, A1)
=IF(B1<=500, A1*0.9, A1)
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
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 Special Education
10 questions
Exploring Valentine's Day with Charlie Brown
Interactive video
•
6th - 10th Grade
18 questions
Valentines Day Trivia
Quiz
•
3rd Grade - University
20 questions
-AR -ER -IR present tense
Quiz
•
10th - 12th Grade
10 questions
Valentine's Day History and Traditions
Interactive video
•
6th - 10th Grade
21 questions
Presidents Day Trivia
Quiz
•
6th - 12th Grade
10 questions
Valentine's Day: History and Modern Celebration
Interactive video
•
9th - 12th Grade
11 questions
Valentine's Day Trivia
Quiz
•
8th - 12th Grade
10 questions
Factor Quadratic Expressions with Various Coefficients
Quiz
•
9th - 12th Grade