Statistics for Every Excel Formula

Click here to take the quiz!

General Stats
Answer Stats
Score Distribution
Your Score History

General Stats

This quiz has been taken 24 times
The average score is 30 of 497

Answer Stats

Category	Formula	% Correct
	SUM	100%
	IF	88%
	MIN	79%
	AVERAGE	75%
	MAX	67%
	VLOOKUP	67%
	COUNT	58%
	T	58%
	COUNTIF	54%
	COS	50%
	OR	50%
	SUMIF	50%
	XLOOKUP	50%
	N	46%
	SIN	46%
Logical	AND	42%
	COUNTIFS	42%
	IFS	42%
	PHI	42%
	TAN	42%
Date and time	DATE	38%
	SUMIFS	38%
	YEAR	38%
	FIND	33%
	INDEX	33%
	MATCH	33%
	CONCAT	29%
	DAY	29%
	HLOOKUP	29%
	LEN	29%
	MEDIAN	29%
	MOD	29%
	MONTH	29%
	PI	29%
	STDEV	29%
	TIME	29%
	TODAY	29%
	HOUR	25%
	INT	25%
	LOG	25%
	LOOKUP	25%
	RAND	25%
	TEXT	25%
	AVERAGEIF	21%
	COT	21%
	IFERROR	21%
	PRODUCT	21%
	RIGHT	21%
	SEC	21%
	SQRT	21%
	AVERAGEIFS	17%
	CONCATENATE	17%
	COUNTA	17%
	LEFT	17%
	MINUTE	17%
	MODE	17%
	NOT	17%
	NOW	17%
	SEARCH	17%
	SECOND	17%
	VALUE	17%
	COUNTBLANK	13%
	DAYS	13%
	DECIMAL	13%
	EDATE	13%
	NA	13%
	QUARTILE	13%
	QUOTIENT	13%
	RANK	13%
	ROUND	13%
	ROUNDDOWN	13%
	ROUNDUP	13%
	SORT	13%
	SUMPRODUCT	13%
	WEEKDAY	13%
Math and trigonometry	ABS	8%
	ACOS	8%
	ASIN	8%
	ATAN	8%
	CEILING	8%
	CODE	8%
	COLUMN	8%
	COMBIN	8%
	CONVERT	8%
	COSH	8%
	DATEDIF	8%
	DEGREES	8%
	DROP	8%
	EVEN	8%
	EXP	8%
	FALSE	8%
	FILTER	8%
	FV	8%
	HYPERLINK	8%
	IFNA	8%
	ISBLANK	8%
	ISERR	8%
	ISERROR	8%
	LN	8%
	LOWER	8%
	MID	8%
	NPER	8%
	NPV	8%
	OFFSET	8%
	PERCENTILE	8%
	PV	8%
	RANK.EQ	8%
	RATE	8%
	ROW	8%
	SIGN	8%
	SINH	8%
	STDEV.P	8%
	STDEVP	8%
	STDEV.S	8%
	TRANSPOSE	8%
	TRIM	8%
	TRUE	8%
	UNIQUE	8%
	UPPER	8%
	VAR	8%
	WORKDAY	8%
	XOR	8%
	ACOT	4%
Lookup and reference	ADDRESS	4%
	BASE	4%
	BITAND	4%
	BITOR	4%
	BITXOR	4%
Information	CELL	4%
	CHAR	4%
	COLUMNS	4%
	CSC	4%
	DATEVALUE	4%
	DAYS360	4%
	DB	4%
	DCOUNT	4%
	EOMONTH	4%
	EXACT	4%
	FLOOR	4%
	FORECAST	4%
	GAUSS	4%
	GCD	4%
	IMAGE	4%
	IMCOS	4%
	IMCOSH	4%
	IMCOT	4%
	IMSEC	4%
	IMSECH	4%
	IMSIN	4%
	IMSINH	4%
	IMTAN	4%
	INTRATE	4%
	ISEVEN	4%
	ISODD	4%
	ISOWEEKNUM	4%
	LARGE	4%
	LCM	4%
	MAP	4%
	NETWORKDAYS	4%
	NUMBERVALUE	4%
	ODD	4%
	POISSON	4%
	POWER	4%
	RANDARRAY	4%
	RANDBETWEEN	4%
	RANK.AVG	4%
	REPLACE	4%
	ROWS	4%
	RSQ	4%
	SCAN	4%
	SECH	4%
	SEQUENCE	4%
	SMALL	4%
	SUBTOTAL	4%
	SUMSQ	4%
	SWITCH	4%
	TANH	4%
	TEXTAFTER	4%
	TEXTBEFORE	4%
	TEXTJOIN	4%
	TEXTSPLIT	4%
	TREND	4%
	VAR.P	4%
	VARP	4%
	VAR.S	4%
	WEEKNUM	4%
	XMATCH	4%
	YEARFRAC	4%
Financial	ACCRINT	0%
	ACCRINTM	0%
	ACOSH	0%
	ACOTH	0%
	AGGREGATE	0%
	AMORDEGRC	0%
	AMORLINC	0%
	ARABIC	0%
	AREAS	0%
Text	ARRAYTOTEXT	0%
	ASC	0%
	ASINH	0%
	ATAN2	0%
	ATANH	0%
Statistical	AVEDEV	0%
	AVERAGEA	0%
	BAHTTEXT	0%
Engineering	BESSELI	0%
	BESSELJ	0%
	BESSELK	0%
	BESSELY	0%
Compatibility	BETADIST	0%
	BETA.DIST	0%
	BETA.INV	0%
	BETAINV	0%
	BIN2DEC	0%
	BIN2HEX	0%
	BIN2OCT	0%
	BINOM.DIST	0%
	BINOMDIST	0%
	BINOM.DIST.RANGE	0%
	BINOM.INV	0%
	BITLSHIFT	0%
	BITRSHIFT	0%
	BYCOL	0%
	BYROW	0%
Add-in and Automation	CALL	0%
	CEILING.MATH	0%
	CEILING.PRECISE	0%
	CHIDIST	0%
	CHIINV	0%
	CHISQ.DIST	0%
	CHISQ.DIST.RT	0%
	CHISQ.INV	0%
	CHISQ.INV.RT	0%
	CHISQ.TEST	0%
	CHITEST	0%
	CHOOSE	0%
	CHOOSECOLS	0%
	CHOOSEROWS	0%
	CLEAN	0%
	COMBINA	0%
	COMPLEX	0%
	CONFIDENCE	0%
	CONFIDENCE.NORM	0%
	CONFIDENCE.T	0%
	CORREL	0%
	COTH	0%
	COUPDAYBS	0%
	COUPDAYS	0%
	COUPDAYSNC	0%
	COUPNCD	0%
	COUPNUM	0%
	COUPPCD	0%
	COVAR	0%
	COVARIANCE.P	0%
	COVARIANCE.S	0%
	CRITBINOM	0%
	CSCH	0%
Cube	CUBEKPIMEMBER	0%
	CUBEMEMBER	0%
	CUBEMEMBERPROPERTY	0%
	CUBERANKEDMEMBER	0%
	CUBESET	0%
	CUBESETCOUNT	0%
	CUBEVALUE	0%
	CUMIPMT	0%
	CUMPRINC	0%
Database	DAVERAGE	0%
	DBCS	0%
	DCOUNTA	0%
	DDB	0%
	DEC2BIN	0%
	DEC2HEX	0%
	DEC2OCT	0%
	DELTA	0%
	DEVSQ	0%
	DGET	0%
	DISC	0%
	DMAX	0%
	DMIN	0%
	DOLLAR	0%
	DOLLARDE	0%
	DOLLARFR	0%
	DPRODUCT	0%
	DSTDEV	0%
	DSTDEVP	0%
	DSUM	0%
	DURATION	0%
	DVAR	0%
	DVARP	0%
	EFFECT	0%
Web	ENCODEURL	0%
	ERF	0%
	ERFC	0%
	ERFC.PRECISE	0%
	ERF.PRECISE	0%
	ERROR.TYPE	0%
	EUROCONVERT	0%
	EXPAND	0%
	EXPON.DIST	0%
	EXPONDIST	0%
	FACT	0%
	FACTDOUBLE	0%
	F.DIST	0%
	FDIST	0%
	F.DIST.RT	0%
	FILTERXML	0%
	FINV	0%
	F.INV	0%
	F.INV.RT	0%
	FISHER	0%
	FISHERINV	0%
	FIXED	0%
	FLOOR.MATH	0%
	FLOOR.PRECISE	0%
	FORMULATEXT	0%
	FREQUENCY	0%
	FTEST	0%
	F.TEST	0%
	FVSCHEDULE	0%
	GAMMA	0%
	GAMMA.DIST	0%
	GAMMADIST	0%
	GAMMA.INV	0%
	GAMMAINV	0%
	GAMMALN	0%
	GAMMALN.PRECISE	0%
	GEOMEAN	0%
	GESTEP	0%
	GETPIVOTDATA	0%
	GROWTH	0%
	HARMEAN	0%
	HEX2BIN	0%
	HEX2DEC	0%
	HEX2OCT	0%
	HSTACK	0%
	HYPGEOMDIST	0%
	HYPGEOM.DIST	0%
	IMABS	0%
	IMAGINARY	0%
	IMARGUMENT	0%
	IMCONJUGATE	0%
	IMCSC	0%
	IMCSCH	0%
	IMDIV	0%
	IMEXP	0%
	IMLN	0%
	IMLOG10	0%
	IMLOG2	0%
	IMPOWER	0%
	IMPRODUCT	0%
	IMREAL	0%
	IMSQRT	0%
	IMSUB	0%
	IMSUM	0%
	INDIRECT	0%
	INFO	0%
	INTERCEPT	0%
	IPMT	0%
	IRR	0%
	ISFORMULA	0%
	ISLOGICAL	0%
	ISNA	0%
	ISNONTEXT	0%
	ISNUMBER	0%
	ISO.CEILING	0%
	ISOMITTED	0%
	ISPMT	0%
	ISREF	0%
	ISTEXT	0%
	JIS	0%
	KURT	0%
	LAMBDA	0%
	LET	0%
	LINEST	0%
	LOG10	0%
	LOGEST	0%
	LOGINV	0%
	LOGNORMDIST	0%
	LOGNORM.DIST	0%
	LOGNORM.INV	0%
	MAKEARRAY	0%
	MAXA	0%
	MAXIFS	0%
	MDETERM	0%
	MDURATION	0%
	MINA	0%
	MINIFS	0%
	MINVERSE	0%
	MIRR	0%
	MMULT	0%
	MODE.MULT	0%
	MODE.SNGL	0%
	MROUND	0%
	MULTINOMIAL	0%
	MUNIT	0%
	NEGBINOMDIST	0%
	NEGBINOM.DIST	0%
	NOMINAL	0%
	NORMDIST	0%
	NORM.DIST	0%
	NORMINV	0%
	NORM.INV	0%
	NORM.S.DIST	0%
	NORMSDIST	0%
	NORMSINV	0%
	NORM.S.INV	0%
	OCT2BIN	0%
	OCT2DEC	0%
	OCT2HEX	0%
	ODDFPRICE	0%
	ODDFYIELD	0%
	ODDLPRICE	0%
	ODDLYIELD	0%
	PDURATION	0%
	PEARSON	0%
	PERCENTRANK	0%
	PERMUT	0%
	PERMUTATIONA	0%
	PHONETIC	0%
	PMT	0%
	POISSON.DIST	0%
	PPMT	0%
	PRICE	0%
	PRICEDISC	0%
	PRICEMAT	0%
	PROB	0%
	PROPER	0%
	QUARTILE.EXC	0%
	QUARTILE.INC	0%
	RADIANS	0%
	RECEIVED	0%
	REDUCE	0%
	REGISTER.ID	0%
	REPT	0%
	ROMAN	0%
	RRI	0%
	RTD	0%
	SERIESSUM	0%
	SHEET	0%
	SHEETS	0%
	SKEW	0%
	SKEW.P	0%
	SLN	0%
	SLOPE	0%
	SORTBY	0%
	SQRTPI	0%
	STANDARDIZE	0%
	STDEVA	0%
	STDEVPA	0%
	STEYX	0%
	STOCKHISTORY	0%
	SUBSTITUTE	0%
	SUMX2MY2	0%
	SUMX2PY2	0%
	SUMXMY2	0%
	SYD	0%
	TAKE	0%
	TBILLEQ	0%
	TBILLPRICE	0%
	TBILLYIELD	0%
	TDIST	0%
	T.DIST	0%
	T.DIST.2T	0%
	T.DIST.RT	0%
	TIMEVALUE	0%
	TINV	0%
	T.INV	0%
	T.INV.2T	0%
	TOCOL	0%
	TOROW	0%
	TRIMMEAN	0%
	TRUNC	0%
	T.TEST	0%
	TTEST	0%
	TYPE	0%
	UNICHAR	0%
	UNICODE	0%
	VALUETOTEXT	0%
	VARA	0%
	VARPA	0%
	VDB	0%
Look and reference	VSTACK	0%
	WEBSERVICE	0%
	WEIBULL	0%
	WEIBULL.DIST	0%
	WORKDAY.INTL	0%
	WRAPCOLS	0%
	WRAPROWS	0%
	XIRR	0%
	XNPV	0%
	YIELD	0%
	YIELDDISC	0%
	YIELDMAT	0%
	Z.TEST	0%
	ZTEST	0%