Aplikasi Spread Sheet
Authored by Umi Umairoh
Computers
10th Grade
Used 50+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
25 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
fungsi yang digunaakan untuk menjumlahkan data yang terdapat pada beberapa sel adalah….
sum
average
min
max
sumif
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Rumus yang dapat diisikan pada cel E7 adalah….
=sum(C7:D7)
=average(C7:D7)
=count(C7:D7)
=C7*D7
=C7XD7
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Rumus yang dapat diisikan pada kolom C10 adalah….
=sum(C4:C8)
=sumif(C4:C8,galaxy mini,B4:B8)
=count(C4:C8)
=sumif(B4:B8,Galaxy Mini,C4:C8)
=sumif(B4:B8,”Galaxy Mini”,C4:C8)
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Rumus statistik yang digunakan untuk mencari nilai rata-rata pada aplikasi spreadsheet adalah….
Min
Max
Average
Med
Mod
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Rumus untuk mengisi kolom E11 adalah….
=average(D6:E10)
=average(D6:D10)
=average(E6:E10)
=average(E6;E10)
=average(D6;D10)
6.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Gambar dibawah ini pada MS Excel menunjukkan …
Maximize
Special event
Minimize
Restore
close
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Rumus Nilai Investasi pada saat ini dalam kolom C5 diisi dengan….
=PV(C4;C3;C2)
=FV(C4;C3;C2)
=PV(C2;C3;C4)
=FV(C2;C3;C4)
=PV(C4:C3:C2)
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 Microsoft
or continue with
%20(1).png)
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
