 nhn ca tp s liu, biu th mc nhn hay mc phng
i ca m so v chun
LARGE (array, k) : Tr v  ln nht th k trong mt tp s liu
MAX (number1, number2, ) : Tr v  ln nht ca mt t
MAXA (number1, number2, ) : Tr v  ln nht ca mt t, bao gm c 

 c.
MIN (number1, number2, ) : Tr v  nh nht ca mt t
MINA (number1, number2, ) : Tr v  nh nht ca mt t, bao gm c 

MODE (number1, number2, ) : Tr v  xut hin nhiu nht trong mt m
 th k c trong mt mng d liu
PERCENTRANK (array, x, significance) : Tr v th hng (v i) ca mt tr trong mt
mng d li pha mng d li
PERMUT (number, number_chosen) : Tr v  cng.
m t  ca tp d lio
 li p h
 hng ca mt s 
SKEW (number1, number2, ) : Tr v  lch c  i xng ca
i quanh tr 
SMALL (array, k) : Tr v  nh nht th k trong mt tp s
 lch chu mu
 lch chu mu, bao gm c nh
tr logic
 lch chu tp hp
 lch chu tp hp, k c ch 
logic
VAR (number1, number2, ) : Tr v  mu
VARA (value1, value2, ) : Tr v u, bao gm c  
VARP (number1, number2, ) : Tr v  tp hp
VARPA (value1, value2, ) : Tr v  tp hp, bao gm c 

quan ging s liu
GAMMADIST (x, alpha, beta, cumulative) : Tr v gamma 
 lch
GAMMAINV (probability, alpha, beta) : Tr v ngho c
 
HYPGEOMDIST (number1, number2, ) : Tr v t ca mt s ln

o c
lognormal ca x (LOGNORMDIST)
LOGNORMDIST (x, mean, standard_dev) : Tr v 
logarit t i vi  
NEGBINOMDIST (number_f, number_s, probability_s) : Tr v i nh th v 
su n tht b
i ca mt llity_s)
NORMDIST (x, mean, standard_dev, cumulative) : Tr v i chun (normal distribution).
c s dng trong vic thm c vic kim tra gi thuyt
n
NORMSDIST (z) : Tr v n tc (standard normal cumulative
distribution function  lch chu
o cn tc
POISSON (x, mean, cumulative) : Tr v   ng
bin c s xy ra trong mt khong thi gian nhnh
t c m
gia hai gii hn
STANDARDIZE (x, mean, standard_dev) : Tr v tr chu i biu th b
standard_dev
TDIST (x, degrees_freedom, tails) : Tr v t ci t), trong
   c sut.
TINV (probability, degrees_freedom) : Tr v  t ci Student.
t kt hp v Student.

d. Các hàm tài chính - financian functions
ACCRINT (issue, first_interest, settlement, rate, par, frequency, basis, calc
t ch nh k
i vi ch 
k hn
AMORDEGRC (cost, date_purchased, first_period, salvage, period, rate, basis) : u hao
trong m i hn s dng cn (s d thng k

u hao
trong m  d thng k 
  t u k t

  m c 
k
COUPDA  
 tip
COUPNCD (settlement, maturity, frequency, basis) : Tr v mt con s th hi
tip k t 
COUPNUM (settlement, maturit lt phi tr trong khong
t n
COUPPCD (settlement, maturity, frequency, basis) : Tr v mt con s th hi

CUMIPMT (rate, nper, pv, sti ti tr i vi
khon vay trong khong thi gian gi
CUMPRINC (rate, nper, pv, start_period, end_period, type) : Tr v tin vi tr i
vi khon vay trong khong thi gian gi
u hao cho mn s d
m dn theo mt mc c nh (fixed-declining balance method) trong mt khong thi
nh.
DDB (cost, u hao cho mn s d

 
 k h tr khong chu
k, s tin tr  sut li tc c nh
a mt kho dng t l
chiu khu vn tr k hn (tr p (tr 
ODDFPRICE (settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency, basis) :
 ng ma ch  (ngn h
hn)
ODDFYIELD (settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency, basis) :
Tr v li nhun ca mt ch  (ngn hn)

 ng ma ch u cul (ngn
hn)
i
nhun ca ch cu (ngn hn)
n phi tr i vi kho
tr n
n vt k hi vi
mt khoc chi tr c thc hinh k vi mt
i
PRICE (se ch
ng mi tc theo chu k
 ng m
$100 ca mt cht khu
 ng m
ca mt chn
 hin ti ca mt kho
RATE t mi k trong m
 tin nh
ht ch

mt  d liu, theo mu kic ch nh.
 trong mt ct ca ma
m d liu, theo mu kic ch nh.
 lch chun ca mt tp hp theo mu, bng
 d liu trong mt ct ca ma m d liu, theo mt
u kic ch nh.
 lch chun ca mt tp h p
hp, bng  d liu trong mt ct ca ma m d liu,
theo mu kic ch nh.