Microsoft Office 2005
Microsoft Office 2007
Microsoft Office 2010
Microsoft Office 2003
Microsoft Office 2011
Rate this question:
Mengurutkan data dari besar ke kecil
Mengurutkan data dari kecil ke besar
Mencari nilai paling besar
Mencari nilai paling keci
Merubah semua huruf besar menjadi huruf kecil
Rate this question:
Mengurutkan data dari besar ke kecil
Mengurutkan data dari kecil ke besar
Mencari nilai paling besar
Mencari nilai paling kecil
Merubah semua huruf kecil menjadi huruf besar
Rate this question:
String
Integer
Float
Double Integer
Decimal
Rate this question:
Workbook
Worsheet
Range
Sel
Sheet
Rate this question:
() , / , ^
+ , - , *
* , x, -
”” , - , *
* , + , -
Rate this question:
$
^
*
#
!
Rate this question:
Sum(D4:D9)
=If D4
=C3*D5
=sum C4,D4
=Avg (D6:D10)
Rate this question:
Centang use 1000 separator (,)
Ubah Decimal Places menjadi 3
Centang Wrap Text
Pada Text Direction pilih Context
Klik Merge Cels
Rate this question:
10
11
12
13
14
Rate this question:
Count
Max
Min
Sum
Average
Rate this question:
Lulus
Tidak Lulus
Koplak
Tidak Koplak
Bingung
Rate this question:
=
>
>=
>>
Rate this question:
=B6*4500
B6*4500
=B7*4500
=B8*4500
=B9*4500
Rate this question:
=C6*2000
C6*2000
=C7*2000
=C7*2000
=C9*2000
Rate this question:
=D6+E6
=SUM(D6:E6)
=SUM(D6;E6)
=SUM(D6:F6)
=SUM(D6:G6)
Rate this question:
=10%*F6
10%*F6
=10%*E6
=10%*G6
=10%*B6
Rate this question:
=IF(E7="A";1000;IF(E7="B";2000;IF(E7="C";3000;0)))
IF(E7="A";1000;IF(E7="B";2000;IF(E7="C";3000;0)))
=IF(E6="A";1000;IF(E6="B";2000;IF(E6="C";3000;0)))
=IF(E6="A";1000;IF(E7="B";2000;IF(E7="C";3000;0)))
=IF(E7="A";1000;IF(E7="B";2000;IF(E8="C";3000;0)))
Rate this question:
IF(C7=1;10%*D7*F7;IF(C7=2;7,5%*D7*F7;IF(C7=3;5%*D7*F7;0)))
=IF(C7=1;10%*D7*F7;IF(C7=2;7,5%*D7*F7;IF(C7=3;5%*D7*F7;0)))
=IF(C6=1;10%*D7*F7;IF(C7=2;7,5%*D7*F7;IF(C7=3;5%*D7*F7;0)))
=IF(C9=1;10%*D7*F7;IF(C7=2;7,5%*D7*F7;IF(C7=3;5%*D7*F7;0)))
=IF(C7=1;10%*D7*F7;IF(C8=2;7,5%*D7*F7;IF(C7=3;5%*D7*F7;0)))
Rate this question:
=(D7*F7)-G7
(D7*F7)-G7
=(D7xF7)-G7
=D7*F7-G7
=(D7*F7)-E7
Rate this question:
IF(B9="AA";"EKONOMI";IF(C9="AB";"UTAMA";IF(C9="AC";"VIP";0)))
=IF(E9="AA";"EKONOMI";IF(C9="AB";"UTAMA";IF(C9="AC";"VIP";0)))
=IF(C9="AA";"EKONOMI";IF(C9="AB";"UTAMA";IF(C9="AC";"VIP";0)))
=IF(C9="AA";"EKONOMI";IF(D9="AB";"UTAMA";IF(C9="AC";"VIP";0)))
=IF(C9="AA";"EKONOMI";IF(C9="AB";"UTAMA";IF(G9="AC";"VIP";0)))
Rate this question:
=IF(D9="EKONOMI";25000;IF(D9="UTAMA";50000;75000))
IF(D9="EKONOMI";25000;IF(D9="UTAMA";50000;75000))
=IF(B9="EKONOMI";25000;IF(D9="UTAMA";50000;75000))
=IF(A9="EKONOMI";25000;IF(D9="UTAMA";50000;75000))
=IF(F9="EKONOMI";25000;IF(D9="UTAMA";50000;75000))
Rate this question:
=IF(OR(D9="VIP";G9>5);10%*G9*H9;0)
IF(OR(D9="VIP";G9>5);10%*G9*H9;0)
=IF(AND(D9="VIP";G9>5);10%*G9*H9;0)
=IF(OR(E9="VIP";G9>5);10%*G9*H9;0)
=IF(OR(D9=VIP;G9>5);10%*G9*H9;0)
Rate this question:
=HLOOKUP(E7;$C$20:$F$21;2;0)
=HLOOKUP(D7;$C$20:$F$21;2;0)
HLOOKUP(C7;$C$20:$F$21;2;0)
=VLOOKUP(C7;$C$20:$F$21;2;0)
=HLOOKUP(C7;$C$20:$F$21;2;0)
Rate this question:
=HLOOKUP(D7>5;10%*E7;0)
IF(D7>5;10%*E7;0)
=IF(D7>5;10%*E7;0)
=IF(E7>5;10%*E7;0)
=IFF(D7>5;10%*E7;0)
Rate this question:
=(F7*E7)-F7
=(D7*E7)-F7
=(D7*E7)-E7
(D7*E7)-F7
=(D7*E7)-D7
Rate this question:
VLOOKUP(LEFT(A6;2);$H$8:$I$12;2)
=VLOOKUP(LEFT(A6;2);$H$8:$I$12;2)
=VLOOKUP(A6;2);$H$8:$I$12;2)
=HLOOKUP(LEFT(A6;2);$H$8:$I$12;2)
=VLOOKUP(MID(A6;2);$H$8:$I$12;2)
Rate this question:
=MID(A6;3;2)
MID(A6;3;2)
=MID(A8;3;2)
=MID(A9;3;2)
=LEFT(A6;3;2)
Rate this question:
VLOOKUP(LEFT(A6;2);$H$8:$J$12;3)
=HLOOKUP(LEFT(A6;2);$H$8:$J$12;3)
=VLOOKUP(MID(A6;2);$H$8:$J$12;3)
=VLOOKUP(LEFT(A6;2);$H$8:$J$12;3)
=HLOOKUP(LEFT(A6;2);$H$8:$J$12;3)
Rate this question:
5
11
9
10
15
Rate this question:
2
4
1
0
3
Rate this question:
11
5
4
9
Salah semua
Rate this question:
=HLOOKUP(LEFT(B6;2);$C$25:$F$27;2)
=HLOOKUP(LEFT(B6;2);Sheet2!$C$25:$F$27;2)
=VLOOKUP(LEFT(B6;2);Sheet1!$C$25:$F$27;2)
=HLOOKUP(LEFT(B6;2);Sheet1!$C$25:$F$27;2)
=HLOOKUP(MID(B6;2);Sheet1!$C$25:$F$27;2)
=VLOOKUP(LEFT(B6;2);$C$25:$F$27;3)
=HLOOKUP(LEFT(B6;2);$C$25:$F$27;3)
=HLOOKUP(LEFT(Sheet1!B6;2);Sheet1!$C$25:$F$27;3)
=HLOOKUP(LEFT(Sheet2!B6;2);$C$25:$F$27;3)
HLOOKUP(LEFT(Sheet1!B6;2);Sheet1!$C$25:$F$27;3)
Rate this question:
=VLOOKUP(MID(B6;4;3);$H$25:$K$29;3)
=VLOOKUP(MID(B6;4;3);$H$25:$K$29;3)
=VLOOKUP(LEFT(B6;4;3);$H$25:$K$29;3)
=VLOOKUP(MID(B6;4;3);Sheet2!$H$25:$K$29;3)
=HLOOKUP(MID(B6;4;3);$H$25:$K$29;3)
Rate this question:
=VLOOKUP(MID(B6;4;3);$H$25:$K$29;3)
=VLOOKUP(MID(B6;4;3);Sheet2!$H$25:$K$29;3)
VLOOKUP(MID(B6;4;3);$H$25:$K$29;3)
=HLOOKUP(MID(B6;4;3);Sheet1!$H$25:$K$29;3)
=VLOOKUP(LEFT(B6;4;3);$H$25:$K$29;3)
Rate this question:
VLOOKUP(MID(B6;4;3);$H$25:$K$29;4)
=VLOOKUP(MID(B6;4;3);Sheet2!$H$25:$K$29;4)
=VLOOKUP(MID(B6;4;3);$H$25:$K$29;4)
=HLOOKUP(MID(B6;4;3);Sheet1!$H$25:$K$29;4)
=VLOOKUP(LEFT(B6;4;3);$H$25:$K$29;4)
Rate this question:
=IF(RIGHT(B6;2)="CS";"CASH";"CREDIT")
=IF(RIGHT(B6;2)="CS";"CASH";IF(RIGHT(B6;2)="CT";"CREDIT";0))
IF(RIGHT(B6;2)="CS";"CASH";IF(RIGHT(B6;2)="CT";"CREDIT";0))
A dan B Benar
A B C Benar
Rate this question:
=IF(I6="CASH";20%*J6;IF(I6="CREDIT";5%*J6;0))
IF(I6="CASH";20%*J6;IF(I6="CREDIT";5%*J6;0))
=IF(I6="CASH";20%*J6;"CREDIT")
=IF(I6="CASH";20%*J6;"CREDIT") IF(I6="CASH";20%*J6;"CREDIT")
A dan B Benar
Rate this question:
MID
LEFT
RiIGHT
RIGHT
LEVT
Rate this question:
MID
LEFT
RIGHT
LEVT
RIHGT
Rate this question:
RIGHT
LEVT
RIHGT
MID
MIT
Rate this question:
Windows 98
LINUX
MAC OS
Microsoft Office
Free BSD
Rate this question:
Winamp
Media Player
XIne
Power DVD
Open Office
Rate this question:
Printer
Monitor
Mouse
LCD Proyektor
Speaker
Rate this question:
Sel Semi absolut
Sel absolut
Sel Full absolut
Range
Sel Relatif
Rate this question:
Speaker
Monitor
Mouse
Printer
LCD Proyektor
Rate this question:
=IF(I6
IF(I6
=IF(I6
=IF(I6>50;"E";IF(I6
=IF(I6
Quiz Review Timeline (Updated): Mar 22, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
Wait!
Here's an interesting quiz for you.