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