Google Sheets formula practice
Pick a formula, read a short explanation, then solve 3 exercises on real data. Each one is checked instantly in your browser, with hints when you get stuck. No signup needed.
VLOOKUPVLOOKUP finds a value in the first column of a table and returns something from the same row.
XLOOKUPXLOOKUP searches one range and returns the matching item from another.
INDEX & MATCHMATCH finds the position of a value in a column.
SUMIFSSUMIFS adds up the numbers in one column, but only for the rows that meet every condition you give it.
COUNTIF & SUMIFCOUNTIF counts the cells that match a condition, and SUMIF adds the numbers next to them.
IFIF checks a condition and returns one value when it is true and another when it is false.
IFS, AND/OR & IFERRORIFERROR replaces an error with something friendlier.
QUERYQUERY runs a small SQL-like language over a range: pick columns, filter rows, group and sort, all in one formula.
FILTERFILTER returns only the rows of a range that meet your conditions, and the result updates automatically when the data changes.
SORT & UNIQUEUNIQUE removes duplicates from a list, and SORT orders a range by one or more columns.
ARRAYFORMULAARRAYFORMULA applies a calculation to whole ranges at once, so one formula in the top cell fills the entire column.
REGEX functionsThe REGEX functions use regular expressions to test, pull out or clean up text.
COUNTIFSCOUNTIFS counts the rows that meet every condition you list.
MAXIFS, MINIFS & AVERAGEIFSMAXIFS, MINIFS and AVERAGEIFS work like SUMIFS, but return the largest, smallest or average value among the rows that match your conditions.
SUM, AVERAGE, MIN & MAXSUM, AVERAGE, MIN and MAX are the first formulas everyone needs: totals, averages and the highest and lowest values in a column.
Absolute references ($)When you copy a formula down, every cell reference moves with it.
LEFT, RIGHT, MID & FINDLEFT, RIGHT and MID pull characters out of text by position.
TRIM, PROPER & SUBSTITUTEImported data is messy: extra spaces, random capitals, unwanted characters.
SPLIT & TEXTJOINSPLIT breaks text into separate cells at a delimiter, like a dash or comma.
Nested IFA nested IF puts one IF inside another to handle more than two outcomes, like turning scores into letter grades.
VLOOKUP approximate matchWith its last argument set to TRUE, VLOOKUP doesn't need an exact match: it finds the largest value in the first column that is less than or equal to what you're looking up.
QUERY group byQUERY with group by turns a list into a summary table, like a pivot table built from one formula.
Excel test coming up?
Take the free timed Excel test: 18 formula tasks in 25 minutes, with an instant score report by skill.
Take the free Excel testWant the full course?
18 lessons and 59 exercises in a real spreadsheet grid, from your first formula to QUERY and REGEX. The first 4 lessons are free.
Start free