PRETEST RUMUS EXCEL
Authored by MUHAMMAD TRIAN
Information Technology (IT)
9th Grade
Used 2+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
5 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 20 pts
Rumus apa yang bisa digunakan untuk pembulatan Nilai ?
=MEDIAN(A2)
=CEILING(A2;10)
=CHOOSE(B1;A1;A2;A3;A4)
=AVERAGE(A2)
2.
MULTIPLE CHOICE QUESTION
30 sec • 20 pts
Rumus mana yang tepat untuk mengisi pada kolom Kembalian !
Semua Jawaban Salah!
=A2*B2
=A2-B2
=B2-A2
3.
MULTIPLE CHOICE QUESTION
30 sec • 20 pts
Rumus mencari nilai Total !
=B2+C2
=B2-C2
=B2*C2
=B2/C2
4.
MULTIPLE CHOICE QUESTION
30 sec • 20 pts
Untuk menambahkan format tanda baca angka, dari 200000 menjadi 200.000. bisa menggunakan ?
5.
MULTIPLE CHOICE QUESTION
30 sec • 20 pts
Untuk menghitung Nilai TOTAL BELANJA pada cell D6 bisa menggunakan rumus......
=AVERAGE(D2:D5)
=TOTAL(D2:D5)
=SUM(D2:D5)
=MAX(D2:D5)
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?
