# Free Excel tests and practice exercises

> A free skills test, test prep for specific jobs, and a graded exercise for every function we teach. No signup.

Source: https://spreadsheetpractice.com/free-excel-tests · Updated October 29, 2026

## Free Excel skills test

Six real tasks in a live grid, from SUM to FILTER. Your level and a study plan in about 10 minutes: [start the test](https://spreadsheetpractice.com/excel-skills-test).

## Test prep by job

| Role | What gets tested |
|---|---|
| [Financial analyst](https://spreadsheetpractice.com/excel-test/financial-analyst) | Lookups across tables, Totals by segment, Locked references in models, Growth and margins |
| [Accountant](https://spreadsheetpractice.com/excel-test/accountant) | Conditional totals, Lookups with gaps, Month-end dates, Cleaning imported data |
| [Administrative assistant](https://spreadsheetpractice.com/excel-test/administrative-assistant) | Totals and averages, Simple rules, Counting entries, Combining names |
| [Data analyst](https://spreadsheetpractice.com/excel-test/data-analyst) | Multi-condition summaries, Lookups, Filtering and sorting, Splitting text |
| [Operations analyst](https://spreadsheetpractice.com/excel-test/operations-analyst) | Rules and flags, Counts by status, Rate lookups, Tiered pricing |
| [Marketing analyst](https://spreadsheetpractice.com/excel-test/marketing-analyst) | Growth and rates, Results by channel, Joining tables, Share of total |
| [HR analyst](https://spreadsheetpractice.com/excel-test/hr-analyst) | Headcount by group, Eligibility rules, Cleaning records, Contract and review dates |
| [Sales analyst](https://spreadsheetpractice.com/excel-test/sales-analyst) | Totals by region and rep, Commission tiers, Weighted prices, Share and cumulative share |
| [Project manager](https://spreadsheetpractice.com/excel-test/project-manager) | Totals and variances, Status rules, Working days, Due dates |

## Practice by function

167 functions, each with live examples and a free graded exercise.

- [Lookup functions](https://spreadsheetpractice.com/functions/category/lookup): [COLUMN](https://spreadsheetpractice.com/functions/column), [COLUMNS](https://spreadsheetpractice.com/functions/columns), [HLOOKUP](https://spreadsheetpractice.com/functions/hlookup), [INDEX](https://spreadsheetpractice.com/functions/index), [INDIRECT](https://spreadsheetpractice.com/functions/indirect), [LOOKUP](https://spreadsheetpractice.com/functions/lookup), [MATCH](https://spreadsheetpractice.com/functions/match), [OFFSET](https://spreadsheetpractice.com/functions/offset), [ROW](https://spreadsheetpractice.com/functions/row), [ROWS](https://spreadsheetpractice.com/functions/rows), [VLOOKUP](https://spreadsheetpractice.com/functions/vlookup), [XLOOKUP](https://spreadsheetpractice.com/functions/xlookup), [XMATCH](https://spreadsheetpractice.com/functions/xmatch)
- [Logical functions](https://spreadsheetpractice.com/functions/category/logic): [AND](https://spreadsheetpractice.com/functions/and), [CHOOSE](https://spreadsheetpractice.com/functions/choose), [IF](https://spreadsheetpractice.com/functions/if), [IFERROR](https://spreadsheetpractice.com/functions/iferror), [IFNA](https://spreadsheetpractice.com/functions/ifna), [IFS](https://spreadsheetpractice.com/functions/ifs), [LET](https://spreadsheetpractice.com/functions/let), [NOT](https://spreadsheetpractice.com/functions/not), [OR](https://spreadsheetpractice.com/functions/or), [SWITCH](https://spreadsheetpractice.com/functions/switch), [XOR](https://spreadsheetpractice.com/functions/xor)
- [Conditional sum and count functions](https://spreadsheetpractice.com/functions/category/conditional): [AVERAGEIF](https://spreadsheetpractice.com/functions/averageif), [AVERAGEIFS](https://spreadsheetpractice.com/functions/averageifs), [COUNTIF](https://spreadsheetpractice.com/functions/countif), [COUNTIFS](https://spreadsheetpractice.com/functions/countifs), [MAXIFS](https://spreadsheetpractice.com/functions/maxifs), [MINIFS](https://spreadsheetpractice.com/functions/minifs), [SUMIF](https://spreadsheetpractice.com/functions/sumif), [SUMIFS](https://spreadsheetpractice.com/functions/sumifs)
- [Math functions](https://spreadsheetpractice.com/functions/category/math): [ABS](https://spreadsheetpractice.com/functions/abs), [AGGREGATE](https://spreadsheetpractice.com/functions/aggregate), [CEILING](https://spreadsheetpractice.com/functions/ceiling), [EXP](https://spreadsheetpractice.com/functions/exp), [FLOOR](https://spreadsheetpractice.com/functions/floor), [INT](https://spreadsheetpractice.com/functions/int), [LN](https://spreadsheetpractice.com/functions/ln), [LOG](https://spreadsheetpractice.com/functions/log), [LOG10](https://spreadsheetpractice.com/functions/log10), [MOD](https://spreadsheetpractice.com/functions/mod), [MROUND](https://spreadsheetpractice.com/functions/mround), [PI](https://spreadsheetpractice.com/functions/pi), [POWER](https://spreadsheetpractice.com/functions/power), [PRODUCT](https://spreadsheetpractice.com/functions/product), [QUOTIENT](https://spreadsheetpractice.com/functions/quotient), [ROUND](https://spreadsheetpractice.com/functions/round), [ROUNDDOWN](https://spreadsheetpractice.com/functions/rounddown), [ROUNDUP](https://spreadsheetpractice.com/functions/roundup), [SIGN](https://spreadsheetpractice.com/functions/sign), [SQRT](https://spreadsheetpractice.com/functions/sqrt), [SUBTOTAL](https://spreadsheetpractice.com/functions/subtotal), [SUM](https://spreadsheetpractice.com/functions/sum), [SUMPRODUCT](https://spreadsheetpractice.com/functions/sumproduct), [SUMSQ](https://spreadsheetpractice.com/functions/sumsq), [TRUNC](https://spreadsheetpractice.com/functions/trunc)
- [Statistical functions](https://spreadsheetpractice.com/functions/category/stats): [AVERAGE](https://spreadsheetpractice.com/functions/average), [COUNT](https://spreadsheetpractice.com/functions/count), [COUNTA](https://spreadsheetpractice.com/functions/counta), [COUNTBLANK](https://spreadsheetpractice.com/functions/countblank), [LARGE](https://spreadsheetpractice.com/functions/large), [MAX](https://spreadsheetpractice.com/functions/max), [MEDIAN](https://spreadsheetpractice.com/functions/median), [MIN](https://spreadsheetpractice.com/functions/min), [MODE](https://spreadsheetpractice.com/functions/mode), [PERCENTILE.EXC](https://spreadsheetpractice.com/functions/percentile-exc), [PERCENTILE.INC](https://spreadsheetpractice.com/functions/percentile-inc), [PERCENTRANK.INC](https://spreadsheetpractice.com/functions/percentrank-inc), [QUARTILE.EXC](https://spreadsheetpractice.com/functions/quartile-exc), [QUARTILE.INC](https://spreadsheetpractice.com/functions/quartile-inc), [RANK.EQ](https://spreadsheetpractice.com/functions/rank-eq), [SMALL](https://spreadsheetpractice.com/functions/small), [STDEV](https://spreadsheetpractice.com/functions/stdev), [STDEV.P](https://spreadsheetpractice.com/functions/stdev-p), [VAR](https://spreadsheetpractice.com/functions/var)
- [Text functions](https://spreadsheetpractice.com/functions/category/text): [CHAR](https://spreadsheetpractice.com/functions/char), [CLEAN](https://spreadsheetpractice.com/functions/clean), [CODE](https://spreadsheetpractice.com/functions/code), [CONCAT](https://spreadsheetpractice.com/functions/concat), [CONCATENATE](https://spreadsheetpractice.com/functions/concatenate), [EXACT](https://spreadsheetpractice.com/functions/exact), [FIND](https://spreadsheetpractice.com/functions/find), [LEFT](https://spreadsheetpractice.com/functions/left), [LEN](https://spreadsheetpractice.com/functions/len), [LOWER](https://spreadsheetpractice.com/functions/lower), [MID](https://spreadsheetpractice.com/functions/mid), [NUMBERVALUE](https://spreadsheetpractice.com/functions/numbervalue), [PROPER](https://spreadsheetpractice.com/functions/proper), [REGEXEXTRACT](https://spreadsheetpractice.com/functions/regexextract), [REGEXREPLACE](https://spreadsheetpractice.com/functions/regexreplace), [REGEXTEST](https://spreadsheetpractice.com/functions/regextest), [REPLACE](https://spreadsheetpractice.com/functions/replace), [REPT](https://spreadsheetpractice.com/functions/rept), [RIGHT](https://spreadsheetpractice.com/functions/right), [SEARCH](https://spreadsheetpractice.com/functions/search), [SUBSTITUTE](https://spreadsheetpractice.com/functions/substitute), [TEXT](https://spreadsheetpractice.com/functions/text), [TEXTAFTER](https://spreadsheetpractice.com/functions/textafter), [TEXTBEFORE](https://spreadsheetpractice.com/functions/textbefore), [TEXTJOIN](https://spreadsheetpractice.com/functions/textjoin), [TEXTSPLIT](https://spreadsheetpractice.com/functions/textsplit), [TRIM](https://spreadsheetpractice.com/functions/trim), [UPPER](https://spreadsheetpractice.com/functions/upper), [VALUE](https://spreadsheetpractice.com/functions/value)
- [Date functions](https://spreadsheetpractice.com/functions/category/date): [DATE](https://spreadsheetpractice.com/functions/date), [DATEDIF](https://spreadsheetpractice.com/functions/datedif), [DATEVALUE](https://spreadsheetpractice.com/functions/datevalue), [DAY](https://spreadsheetpractice.com/functions/day), [DAYS](https://spreadsheetpractice.com/functions/days), [EDATE](https://spreadsheetpractice.com/functions/edate), [EOMONTH](https://spreadsheetpractice.com/functions/eomonth), [HOUR](https://spreadsheetpractice.com/functions/hour), [ISOWEEKNUM](https://spreadsheetpractice.com/functions/isoweeknum), [MINUTE](https://spreadsheetpractice.com/functions/minute), [MONTH](https://spreadsheetpractice.com/functions/month), [NETWORKDAYS](https://spreadsheetpractice.com/functions/networkdays), [NETWORKDAYS.INTL](https://spreadsheetpractice.com/functions/networkdays-intl), [NOW](https://spreadsheetpractice.com/functions/now), [SECOND](https://spreadsheetpractice.com/functions/second), [TIME](https://spreadsheetpractice.com/functions/time), [TIMEVALUE](https://spreadsheetpractice.com/functions/timevalue), [TODAY](https://spreadsheetpractice.com/functions/today), [WEEKDAY](https://spreadsheetpractice.com/functions/weekday), [WEEKNUM](https://spreadsheetpractice.com/functions/weeknum), [WORKDAY](https://spreadsheetpractice.com/functions/workday), [WORKDAY.INTL](https://spreadsheetpractice.com/functions/workday-intl), [YEAR](https://spreadsheetpractice.com/functions/year), [YEARFRAC](https://spreadsheetpractice.com/functions/yearfrac)
- [Dynamic array functions](https://spreadsheetpractice.com/functions/category/dynamic-arrays): [BYCOL](https://spreadsheetpractice.com/functions/bycol), [BYROW](https://spreadsheetpractice.com/functions/byrow), [CHOOSECOLS](https://spreadsheetpractice.com/functions/choosecols), [CHOOSEROWS](https://spreadsheetpractice.com/functions/chooserows), [DROP](https://spreadsheetpractice.com/functions/drop), [FILTER](https://spreadsheetpractice.com/functions/filter), [HSTACK](https://spreadsheetpractice.com/functions/hstack), [LAMBDA](https://spreadsheetpractice.com/functions/lambda), [MAKEARRAY](https://spreadsheetpractice.com/functions/makearray), [MAP](https://spreadsheetpractice.com/functions/map), [REDUCE](https://spreadsheetpractice.com/functions/reduce), [SCAN](https://spreadsheetpractice.com/functions/scan), [SEQUENCE](https://spreadsheetpractice.com/functions/sequence), [SORT](https://spreadsheetpractice.com/functions/sort), [SORTBY](https://spreadsheetpractice.com/functions/sortby), [TAKE](https://spreadsheetpractice.com/functions/take), [TOCOL](https://spreadsheetpractice.com/functions/tocol), [TOROW](https://spreadsheetpractice.com/functions/torow), [TRANSPOSE](https://spreadsheetpractice.com/functions/transpose), [UNIQUE](https://spreadsheetpractice.com/functions/unique), [VSTACK](https://spreadsheetpractice.com/functions/vstack)
- [Financial functions](https://spreadsheetpractice.com/functions/category/finance): [FV](https://spreadsheetpractice.com/functions/fv), [IRR](https://spreadsheetpractice.com/functions/irr), [NPER](https://spreadsheetpractice.com/functions/nper), [NPV](https://spreadsheetpractice.com/functions/npv), [PMT](https://spreadsheetpractice.com/functions/pmt), [PV](https://spreadsheetpractice.com/functions/pv), [RATE](https://spreadsheetpractice.com/functions/rate)
- [Information functions](https://spreadsheetpractice.com/functions/category/info): [ISBLANK](https://spreadsheetpractice.com/functions/isblank), [ISERR](https://spreadsheetpractice.com/functions/iserr), [ISERROR](https://spreadsheetpractice.com/functions/iserror), [ISEVEN](https://spreadsheetpractice.com/functions/iseven), [ISLOGICAL](https://spreadsheetpractice.com/functions/islogical), [ISNA](https://spreadsheetpractice.com/functions/isna), [ISNUMBER](https://spreadsheetpractice.com/functions/isnumber), [ISODD](https://spreadsheetpractice.com/functions/isodd), [ISTEXT](https://spreadsheetpractice.com/functions/istext), [NA](https://spreadsheetpractice.com/functions/na)

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
