Uji Pemahaman Excel
Authored by Michael Fadly Lakoy
Computers
7th Grade
Used 5+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
50 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 2 pts
Nilai cell H3=20, H4=10, H5=20, H6=10 jika diberikan formula =AVERAGE(H3;H6), akan menghasilkan...
5
10
15
20
2.
MULTIPLE CHOICE QUESTION
30 sec • 2 pts
Apabila cell A5 bernilai 60 dan B5 bernilai 5, maka formula yang menghasilkan TRUE adalah...
=OR(A5A5)
=NOT(A5=60)
=AND(A5>B5;B5)
=AND(A5<75 A5=B5)>
3.
MULTIPLE CHOICE QUESTION
1 min • 2 pts
Range B5:H5 pada Microsoft Excel memiliki jumlah cell sebanyak...
4
5
6
7
4.
MULTIPLE CHOICE QUESTION
1 min • 2 pts
Cell G9 memiliki teks "data" dan G 10 memiliki teks "Siswa". Agar menghasilkan keluaran "dataSiswa", maka menggunakan formula...
G9&G10
G9+G10
=G9+G10
=G9&G10
5.
MULTIPLE CHOICE QUESTION
1 min • 2 pts
Formula hasil rata-rata dari data pada cell B2 sampai B9 adalah...
AVERAGE(B2;B9)
MEDIAN(B2;B9)
MAX(B2;B9)
SUM(B2;B9)
6.
MULTIPLE CHOICE QUESTION
1 min • 2 pts
Fitur yang dapat memberikan warna pada cell adalah...
Format font
Fill color
Format
number
Freeze
panes
7.
MULTIPLE CHOICE QUESTION
1 min • 2 pts
Berapa sel yang dihitung yang terdapat dalam rumus =AVERAGE(B2:B8) ?
6
7
4
10
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?
