Free exercises
Start with these ten
Ten exercises from the track, free, in the order they are meant to be taken. Type a formula, press Check, and the page names the rule you missed. What you finish is kept in this browser, and signing in carries it to the others.
Take them in this order
- SUM: total a column Total a column with one function instead of typing every cell.
- AVERAGE: mean of a score list Turn five scores into one class average that updates itself.
- COUNTIF: count one condition Count the rows that meet one condition, and get the edges of the range right.
- IF: one test, two answers Write a decision that returns one of two values, chosen by a single test.
- SUMIF: total one region Total only the rows that match a region.
- ROUND: money to two decimals Round a marked-up total once, and know that the stored value changed.
- VLOOKUP: exact match Pull a salary out of a table by its ID, with the exact-match flag written out.
- LEN, LEFT and RIGHT: count and cut Measure a string, then cut fixed pieces from either end.
- CONCAT and the & operator Join two cells into one string, with the space passed in as its own piece.
- SUMIFS: two conditions at once Total the rows that meet two conditions at once instead of filtering the table first.
Get full access to the whole course
Full access opens the other 76 exercises, in the same one-task shape.