Tes Pemahaman Perangkat Pengolah Tabel
Authored by Abi Febrianto
Computers
University
Used 5+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
40 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Untuk mengisi sel C4 digunakan fungsi ....
=VLOOKUP(B4;$N$3:$Q9;2)
=VLOOKUP(B4;$N$3:$Q9;1)
=O4
=HLOOKUP(B4;$N$3:$Q9;2)
=HLOOKUP(B4;$N$3:$Q9;1)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Untuk mengisi sel J4 digunakan format …
Currency
Accounting
Percentage
General
Date
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Apabila rumus yang digunakan benar, sel C4 berisi ….
B1
SUNGLARE
AFRIKA
BUNGA
AMERIKA
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Apabila syarat DISC HARGA 25 % untuk VOL di atas 50 maka rumus yang dipergunakan...
= IF D4>50 Then writeln “25%” else writeln “0”
= IF D4>50Then “25%” else “0”
= IF D4>50; “25%”; “0”
= IF (D4>50;25%;0)
= IF VOL>50, DISC 25%, 0
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Untuk mengisi JAM TERLAMBAT menggunakan rumus .....
=HOUR(C6-$A$3)
=MINUTE(C6-$A$3)
=(C6-$A$3)
=HOUR($A$3-C6)
=$B$6-C6
6.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Agar muncul tampilan seperti di atas menggunakan ....
Data Filter
Data Sortir
Auto Sum
Sort Descending
Formula
7.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Formula untuk menghitung 20+4x24 adalah...
=20+4x24
=(20+4*24)
=(20+4x24)
=20+(4*24)
=(20+4)*24
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?
