Every Excel Formula

Try to name every excel formula ever released by the Microsoft Devs

.INTL formulas arbitrarily removed to get under the 500 row limit

Quiz by

Rate:

Last updated: June 26, 2023

You have not attempted this quiz yet.

More quiz info >>

First submitted	June 26, 2023
Times taken	20
Average score	5.6%
Report this quiz	Report

Quiz and answer stats >>

Friends stats >>

35:00

Enter answer here

/ 497 guessed

The quiz is paused. You have remaining.

Scoring
You scored / = %

      This beats or equals
      % of test takers
      also scored 100%
      
The average score is 

        Your high score is
        
      
Your fastest time is 
more stats >>
friends stats >>

Keep scrolling down for answers and more stats ...

Category	Formula
Add-in and Automation	CALL
	EUROCONVERT
	REGISTER.ID
Compatibility	BETADIST
	BETAINV
	BINOMDIST
	CEILING
	CONFIDENCE
	COVAR
	CRITBINOM
	EXPONDIST
	FDIST
	FINV
	FLOOR
	FTEST
	GAMMADIST
	GAMMAINV
	HYPGEOMDIST
	LOGINV
	LOGNORMDIST
	MODE
	NEGBINOMDIST
	NORMDIST
	NORMSDIST
	NORMSINV
	PERCENTILE
	PERCENTRANK
	POISSON
	QUARTILE
	RANK
	STDEV
	STDEVP
	TDIST
	TINV
	TTEST
	VAR
	VARP
	WEIBULL
	ZTEST
	CHIDIST
	CHIINV
	CHITEST
	NORM.INV
Cube	CUBEKPIMEMBER
	CUBEMEMBER
	CUBEMEMBERPROPERTY
	CUBERANKEDMEMBER
	CUBESET
	CUBESETCOUNT
	CUBEVALUE
Database	DAVERAGE
	DCOUNT
	DCOUNTA
	DGET
	DMAX
	DMIN
	DPRODUCT
	DSTDEV
	DSTDEVP
	DSUM
	DVAR
	DVARP
Date and time	DATE
	DATEDIF
	DATEVALUE
	DAY
	DAYS
	DAYS360
	EDATE
	EOMONTH
	HOUR
	ISOWEEKNUM
	MINUTE
	MONTH
	NETWORKDAYS
	NOW
	SECOND
	TIME
	TIMEVALUE
	TODAY
	WEEKDAY
	WEEKNUM
	WORKDAY
	WORKDAY.INTL
	YEAR
	YEARFRAC
Engineering	BESSELI
	BESSELJ
	BESSELK
	BESSELY
	BIN2DEC
	BIN2HEX
	BIN2OCT
	BITAND
	BITLSHIFT
	BITOR
	BITRSHIFT
	BITXOR
	COMPLEX
	CONVERT
	DEC2BIN
	DEC2HEX
	DEC2OCT
	DELTA
	ERF
	ERF.PRECISE
	ERFC
	ERFC.PRECISE
	GESTEP
	HEX2BIN
	HEX2DEC
	HEX2OCT
	IMABS
	IMAGINARY
	IMARGUMENT
	IMCONJUGATE
	IMCOS
	IMCOSH
	IMCOT
	IMCSC
	IMCSCH
	IMDIV
	IMEXP
	IMLN
	IMLOG10
	IMLOG2
	IMPOWER
	IMPRODUCT
	IMREAL
	IMSEC
	IMSECH
	IMSIN
	IMSINH
	IMSQRT
	IMSUB
	IMSUM
	IMTAN
	OCT2BIN
	OCT2DEC
	OCT2HEX
Financial	ACCRINT
	ACCRINTM
	AMORDEGRC
	AMORLINC
	COUPDAYBS
	COUPDAYS
	COUPDAYSNC
	COUPNCD
	COUPNUM
	COUPPCD
	CUMIPMT
	CUMPRINC
	DB
	DDB
	DISC
	DOLLARDE
	DOLLARFR
	DURATION
	EFFECT
	FV
	FVSCHEDULE
	INTRATE
	IPMT
	IRR
	ISPMT
	MDURATION
	MIRR
	NOMINAL
	NPER
	NPV
	ODDFPRICE
	ODDFYIELD
	ODDLPRICE
	ODDLYIELD
	PDURATION
	PMT
	PPMT
	PRICE
	PRICEDISC
	PRICEMAT
	PV
	RATE
	RECEIVED
	RRI
	SLN
	STOCKHISTORY
	SYD
	TBILLEQ
	TBILLPRICE
	TBILLYIELD
	VDB
	XIRR
	XNPV
	YIELD
	YIELDDISC
	YIELDMAT
Information	CELL
	ERROR.TYPE
	INFO
	ISBLANK
	ISERR
	ISERROR
	ISEVEN
	ISFORMULA
	ISLOGICAL
	ISNA
	ISNONTEXT
	ISNUMBER
	ISODD
	ISOMITTED
	ISREF
	ISTEXT
	N
	NA
	SHEET
	SHEETS
	TYPE
Logical	AND
	BYCOL
	BYROW
	FALSE
	IF
	IFERROR
	IFNA
	IFS
	LAMBDA
	LET
	MAKEARRAY
	MAP
	NOT
	OR
	REDUCE
	SCAN
	SWITCH
	TRUE
	XOR
Look and reference	VSTACK
	WRAPCOLS
	WRAPROWS
Lookup and reference	ADDRESS
	AREAS
	CHOOSE
	CHOOSECOLS
	CHOOSEROWS
	COLUMN
	COLUMNS
	DROP
	EXPAND
	FILTER

Category	Formula
Lookup and Reference	FORMULATEXT
	GETPIVOTDATA
	HLOOKUP
	HSTACK
	HYPERLINK
	IMAGE
	INDEX
	INDIRECT
	LOOKUP
	MATCH
	OFFSET
	ROW
	ROWS
	RTD
	SORT
	SORTBY
	TAKE
	TOCOL
	TOROW
	TRANSPOSE
	UNIQUE
	VLOOKUP
	XLOOKUP
	XMATCH
Math and trigonometry	ABS
	ACOS
	ACOSH
	ACOT
	ACOTH
	AGGREGATE
	ARABIC
	ASIN
	ASINH
	ATAN
	ATAN2
	ATANH
	BASE
	CEILING.MATH
	CEILING.PRECISE
	COMBIN
	COMBINA
	COS
	COSH
	COT
	COTH
	CSC
	CSCH
	DECIMAL
	DEGREES
	EVEN
	EXP
	FACT
	FACTDOUBLE
	FLOOR.MATH
	FLOOR.PRECISE
	GCD
	INT
	ISO.CEILING
	LCM
	LN
	LOG
	LOG10
	MDETERM
	MINVERSE
	MMULT
	MOD
	MROUND
	MULTINOMIAL
	MUNIT
	ODD
	PI
	POWER
	PRODUCT
	QUOTIENT
	RADIANS
	RAND
	RANDARRAY
	RANDBETWEEN
	ROMAN
	ROUND
	ROUNDDOWN
	ROUNDUP
	SEC
	SECH
	SEQUENCE
	SERIESSUM
	SIGN
	SIN
SINH
SQRT
SQRTPI
SUBTOTAL
SUM
SUMIF
SUMIFS
SUMPRODUCT
SUMSQ
SUMX2MY2
SUMX2PY2
SUMXMY2
TAN
TANH
TRUNC
Statistical	AVEDEV
	AVERAGE
	AVERAGEA
	AVERAGEIF
	AVERAGEIFS
	BETA.DIST
	BETA.INV
	BINOM.DIST
	BINOM.DIST.RANGE
	BINOM.INV
	CHISQ.DIST
	CHISQ.DIST.RT
	CHISQ.INV
	CHISQ.INV.RT
	CHISQ.TEST
	CONFIDENCE.NORM
	CONFIDENCE.T
	CORREL
	COUNT
	COUNTA
	COUNTBLANK
	COUNTIF
	COUNTIFS
	COVARIANCE.P
	COVARIANCE.S
	DEVSQ
	EXPON.DIST
	F.DIST
	F.DIST.RT
	F.INV
	F.INV.RT
	FISHER
	FISHERINV
	FORECAST
	FREQUENCY
	F.TEST
	GAMMA
	GAMMA.DIST
	GAMMA.INV
	GAMMALN
	GAMMALN.PRECISE
	GAUSS
	GEOMEAN
	GROWTH
	HARMEAN
	HYPGEOM.DIST
	INTERCEPT
	KURT
	LARGE
	LINEST
	LOGEST
	LOGNORM.DIST
	LOGNORM.INV
	MAX
	MAXA
	MAXIFS
	MEDIAN
	MIN
	MINIFS
	MINA
	MODE.MULT
	MODE.SNGL
	NEGBINOM.DIST
	NORM.DIST
NORMINV
NORM.S.DIST
NORM.S.INV
PEARSON
PERCENTILE
PERCENTRANK
PERMUT
PERMUTATIONA
PHI
POISSON.DIST
PROB
QUARTILE.EXC
QUARTILE.INC
RANK.AVG
RANK.EQ
RSQ
SKEW
SKEW.P
SLOPE
SMALL
STANDARDIZE
STDEV.P
STDEV.S
STDEVA
STDEVPA
STEYX
T.DIST
T.DIST.2T
T.DIST.RT
T.INV
T.INV.2T
TREND
TRIMMEAN
T.TEST
VAR.P
VAR.S
VARA
VARPA
WEIBULL.DIST
Z.TEST
Text	ARRAYTOTEXT
	ASC
	BAHTTEXT
	CHAR
	CLEAN
	CODE
	CONCAT
	CONCATENATE
	DBCS
	DOLLAR
	EXACT
	FIND
	FIXED
	JIS
	LEFT
	LEN
	LOWER
	MID
	NUMBERVALUE
	PHONETIC
	PROPER
	REPLACE
	REPT
	RIGHT
	SEARCH
	SUBSTITUTE
	T
	TEXT
	TEXTAFTER
	TEXTBEFORE
	TEXTJOIN
	TEXTSPLIT
	TRIM
	UNICHAR
	UNICODE
	UPPER
	VALUE
	VALUETOTEXT
Web	ENCODEURL
	FILTERXML
	WEBSERVICE

Comments

No comments yet

Countries of the World Quiz

US States Quiz

Countries of Europe Quiz

Countries by Borders in 90 Seconds

Country Flags Quiz #1

World Capitals Quiz

All Country Flags of the World

NBA Teams Quiz

Central America and Caribbean Map Quiz

Countries of the World - One Minute Sprint

East Asia Map Quiz

U.S. Baby Girl Names by Decade

Elements of the Periodic Table Quiz

Asia Map Quiz

Fast Typing Test - 100 WPM Challenge

Save Your Progress