Jadi member untuk membuka semua latihan + Tanya AI.
Isi sel yang diminta, lalu tekan Cek jawaban.
144 latihan · 101 gratis
SUM
INT
QUOTIENT
MOD
SUMIF
ROUND
SUMIFS
SUMPRODUCT
ROUNDUP
CEILING.MATH
SUBTOTAL
AGGREGATE
AVERAGE
COUNTA
COUNT
COUNTBLANK
MAX
MIN
COUNTIF
AVERAGEIF
COUNTIFS
MINIFS
MAXIFS
MEDIAN
MODE.SNGL
RANK.EQ
LARGE
SMALL
STDEV.S
CORREL
FORECAST.LINEAR
FREQUENCY
IF
AND
OR
NOT
IFERROR
IFS
SWITCH
XOR
IFNA
VLOOKUP
PROPER
TRIM
UPPER
LEFT
RIGHT
LEN
TEXTBEFORE
TEXTAFTER
CLEAN
MID
VALUE
SEARCH
ISNUMBER
TEXT
TEXTJOIN
FIND
EXACT
SUBSTITUTE
REPLACE
TEXTSPLIT
REGEXEXTRACT
DAY
MONTH
YEAR
TODAY
EOMONTH
EDATE
TIME
DAYS
WEEKDAY
NETWORKDAYS
DATE
DATEDIF
WORKDAY
HOUR
MINUTE
YEARFRAC
NETWORKDAYS.INTL
HLOOKUP
INDEX
MATCH
XLOOKUP
CHOOSE
ROW
TRANSPOSE
XMATCH
ADDRESS
OFFSET
INDIRECT
LOOKUP
UNIQUE
SORT
FILTER
SEQUENCE
TOCOL
SORTBY
TAKE
VSTACK
DROP
CHOOSECOLS
WRAPROWS
GROUPBY
PIVOTBY
LET
LAMBDA
MAP
BYROW
REDUCE
SCAN
MAKEARRAY
PMT
FV
PV
NPER
SLN
DDB
IPMT
PPMT
RATE
EFFECT
NPV
IRR
ISBLANK
ISTEXT
ISODD
ISFORMULA
ISERROR
ERROR.TYPE
DSUM
DCOUNT
DAVERAGE
DGET
CONVERT
DEC2BIN
BIN2DEC
DEC2HEX
Tidak ada soal yang cocok.