Excel practice exercises

Graded exercises in a real spreadsheet grid. Type the formula, get instant feedback, move to the next one.

Most of LearnExcel's exercises sit next to the function they practice: open any guide in the function reference and use the button at the bottom. The pages below are different: two sets that combine functions you have already learned into a single formula, which is where most people get stuck, and practice questions for the Excel tests used in job interviews, including finance and banking roles.

• Excel mock test: 12 questions in 15 minutes

  A timed test in the style of pre-employment assessments, with your score and weak spots.

• Excel for finance interviews: the modeling test questions that come up

  8 questions on the functions every analyst test uses, with computed answers, the traps graders look for, and a graded exercise for each.

• Excel test for a job interview: what's tested and how to practice

  10 questions in the style of real pre-employment Excel tests, with answers, the mistakes that cost points, and a graded exercise for each.

• Combine & Solve: IF + AND/OR/VLOOKUP

  Real decisions almost never depend on just one condition. These five exercises nest IF together with AND, OR, and a lookup to encode an actual business rule.

• Nested Text Functions

  Real text rarely comes in a fixed shape. These five exercises combine SEARCH, MID, LEFT, IFERROR, and INDEX/MATCH to parse and restructure text whose pieces move around.