Row
Cell
Column
Sheet
Range
Rate this question:
C
A
B
A atau B
B atau C
Rate this question:
Divide
Add
Multiply
Ampersand
Eksponen
Rate this question:
Number
Aligment
Border
Pattern
Paragraph
Rate this question:
-
=
*
+
%
Rate this question:
24
22
19
14
11
Rate this question:
MAX
AVERAGE
AUTOSUM
MIN
SUM
Rate this question:
LOOKUP
FIND
Searching
HLOOKUP
VLOOKUP
Rate this question:
F2
F3
F4
F5
F6
Rate this question:
XXXXXXXX
@@@@@
&&&&&&&
########
!!!!!!!!!!!!!!!!!!
Rate this question:
SUM(E5:E9)
AVERAGE (E5:E9)
=SUM(E5:E9)
=AVERAGE(E5:E9)
=MAX(E5:E9)
Rate this question:
Enter
Insert
Bottom
Percentage
Currency
Rate this question:
Center
Justify
Left
General
Merger and Center
Rate this question:
=SUM(B3:D6)
=MAX(B3:D6)
=COUNT(B3:D3)
=AVERAGE(B3:D3)
=SUM(B3:D3)
Rate this question:
=IF(A5>5)5,A1=200
=IF(A1>5,A1)=”LULUS”,B1=”TIDAK”
=IF(A1>5,”SARJANA”,”SMA”)
=IF(A1>5)=”LULUS”,B1=”TIDAK”
=IF(A1>5,A1*B1,A1…B1)
Rate this question:
7500
6000
5000
3500
1500
Rate this question:
IND
DON
NES
SIA
NDO
Rate this question:
=B4*D4
=B11*E11
=C9*E11
=C11*E9
=B9*D9
Rate this question:
Jika kode huruf kiri = SM maka Semen
Jika kode huruf ke-2 sebanyak 1 = SM maka Semen
Jika kode huruf ke-1 sebanyak 2 = SM maka Semen
Jika kode huruf ke-2 sebanyak 2 = SM maka Semen
Jika kode huruf kanan = SM maka Semen
Rate this question:
=IF(
IF(B6
B6
IF
=IF(B6
C
D
Jelek
Baik
Emas
Rate this question:
=IF(A3>100,”=,”Door Prize”,”Kasihan Deh Lo”)
=IF(A3>=100,”Door Prize”,”Kasihan Deh Lo”)
=IF(A3>100,”Door Prize”,”Kasihan Deh Lo”)
.=IF(A3=100,”Door Prize”,”Kasihan Deh Lo”)
=IF(A3
Rate this question:
SUM
MAX
AUTOSUM
COUNT
AVERAGE
Rate this question:
=MAX(B2:D2)
=SUM(B2:C2)
=COUNT(D2:C2)
=MIN(B2:D2)
=AVERAGE(B2:D2)
Rate this question:
57
50
43
14
64
Rate this question:
=IF(C7>=70,”LULUS”,”REMIDIAL”)
=IF(B7
=IF(C7>70,”LULUS”,”REMIDIAL”)
=IF(B7>70,”LULUS”,”REMIDIAL”)
=IF(B7>=70,”LULUS”,”REMIDIAL”)
Rate this question:
49
50
100
200
300
Rate this question:
False
Anjing
Bebek
Cicak
Kuda
Rate this question:
=
&
+
@
$
Rate this question:
=MID(”INDONESIA”,1,3)
=MID(”INDONESIA”,3,3)
=MID(”INDONESIA”,4,3)
=LEFT(”INDONESIA”,3,3)
=RIGHT(”INDONESIA”,4,3)
Rate this question:
SM
UN
AN
SA
MA
Rate this question:
=HLOOKUP(B29,$B$30:$E$34,1)
=HLOOKUP(B30,$B$36:$D$40,2)
=VLOOKUP(B29,$B$30:$D$34,1)
=VLOOKUP(B30,$B$36:$D$40,2)
=VLOOKUP(B30,$B$36:$D$40,3)
Rate this question:
Insert
Formulas
Review
View
Data
Rate this question:
Dari besar ke kecil
Dari kecil ke besar
Acak
Berurutan
Berkurang
Rate this question:
Merubah susunan data ke bentuk semula
Menyusun data secara acak
Menyusun data secara Descending
Menyusun data secara Ascending
Mencari data secara berurutan
Rate this question:
Menggunakan data dari besar ke kecil
Menggunakan data dari kecil ke besar
Menampilkan data dengan syarat tertentu
Membuang data dengan syarat tertentu
Menduplikasi data dengan syarat tertentu
Rate this question:
Insert Chart
View Chart
Review Chart
Data Sort
Formula
Rate this question:
Column
Bar
Pie
X Y
Area
Rate this question:
Column
Bar
Pie
X Y
Area
Rate this question:
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.