Excel: practice, test and prove it

Multiple-choice test on references, lookups, SUMIF, pivot tables and cleaning data.

FreeNo sign-up to testNo attempts yet

Start the excel test Read the first lesson

Office and accounts roles test Excel with a short quiz or a small task. The questions cluster around references, lookups, conditional sums and pivot tables. Every question here comes with the reason for the right answer.

Benchmark: 80% on a 10-question test is the pass mark used here; it matches common screening levels for admin and accounts roles. Requirements vary by employer.

Lessons

Relative and absolute referencesWhy a formula breaks when you copy it, and how the dollar sign fixes it.Lesson 1

Lookups, SUMIF and COUNTIFThe three functions that turn a list into answers, with the mistakes that make them return errors.Lesson 2

Cleaning data and building a first pivot tableRemove duplicates, fix text numbers, then summarise thousands of rows in a minute.Lesson 3

IF, AND, OR and nested conditionsHow to write a formula that makes a decision, combine several tests, and avoid the nesting mistakes that return wrong answers.Lesson 4

Interview prep

Excel interview questions for office rolesThe questions that come up for admin, accounts and operations roles, answered the way an interviewer wants to hear them.6 questions

Excel practical scenariosScenario questions where the interviewer describes a sheet and asks what you would do.6 questions

Certificate

Free with an accountA PDF with your name, best score and date. Records this site's tests only.

Common questions

What Excel level do office jobs need?

References, SUM/AVERAGE, SUMIF/COUNTIF, VLOOKUP or XLOOKUP, sorting and filtering, and a basic pivot table cover most admin and accounts screenings.

Is this a practical test?

It is a knowledge test. Practical tests give you a workbook; the same functions come up, so the questions here prepare you for both.

Which version of Excel is assumed?

Any recent version. XLOOKUP is mentioned where it applies, but every answer also works with VLOOKUP.

Excel test for interviewWhat the screening round looks like, with a 5-question sample.