Quick skill test · 20 questions · 20 minutes · Free

Excel Test for Interview

Practice for the Excel tests employers set in interviews — formulas and lookups such as SUMIFS and XLOOKUP, cleaning and analysing data, PivotTables and charts, and the shortcuts, error-fixing and good habits interviewers look for. Pass to earn Excel for Interviews SOA-XLI.

What is the Excel Test for Interview?

The Excel Test for Interview is a free intermediate-level, 20-minute skill test from Science of Apps. Practice for the Excel tests employers set in interviews — formulas and lookups such as SUMIFS and XLOOKUP, cleaning and analysing data, PivotTables and charts, and the shortcuts, error-fixing and good habits interviewers look for. Score 70% or more on its 20 questions to earn a verifiable Excel for Interviews certificate (SOA-XLI). Every question is based on published standards and research — including Excel functions (alphabetical) (Microsoft Support), Overview of PivotTables and PivotCharts (Microsoft Support), Available chart types in Office (Microsoft Support) — and each answer is explained with its source.

Built for your job title

Data analyst applicant, Financial analyst applicant, Operations applicant, Administrative applicant and Business analyst applicant — and anyone who wants quick, verifiable proof of Excel Interview skills for a CV or LinkedIn.

  • Data analyst applicant
  • Financial analyst applicant
  • Operations applicant
  • Administrative applicant
  • Business analyst applicant

What the test covers

Four skill areas with 5 questions each, drawn from a bank of 10 per area, so a retake brings questions you haven't seen.

  1. 01

    Formulas and Lookups

    25%
    • Cell references
    • Conditional functions
    • Lookups
  2. 02

    Cleaning and Analysing Data

    25%
    • Text and date functions
    • Removing duplicates
    • Dynamic arrays and errors
  3. 03

    PivotTables and Charts

    25%
    • Summarising data
    • Refreshing and grouping
    • Choosing charts
  4. 04

    Interview Tasks and Good Practice

    25%
    • Shortcuts
    • Accuracy habits
    • What-if analysis

Independent skills test. Science of Apps is not affiliated with, endorsed by or sponsored by Microsoft. Product and exam names are trademarks of their owners. Passing earns a Science of Apps certificate, not a certification issued by Microsoft.

Based on published standards

The questions are original scenarios, and each one names the public standard, official guide or research it draws on — shown under the question while you answer, and linked in your review. These are the sources behind this test:

Try a sample question

The formula =B2*$E$1 copied down a column keeps which reference fixed?

  1. $E$1
  2. neither reference
  3. B2
  4. both B2 and E1
Show the answer

A. $E$1 — $ makes a reference absolute. The real test has 20 questions like this.

How the test works

  1. 20 minutes, 20 questions

    One question per screen, with a progress bar and a countdown. Your progress is saved on this device if you need to pause.

  2. Graded on our server

    Answers reach the page only after you submit, so the certificate can only be earned by passing.

  3. Every answer explained

    Pass or not, you see every question with the right answer, why, and the source behind it. Pass mark 70%, distinction 90%.

  4. Your certificate

    Founder-signed, with a QR code and credential ID. Download PDF or PNG, add to LinkedIn, and it's emailed to you.

What you earn

A Science of Apps certificate for Office & Productivity Software: ivory paper with a gold medal
LinkedIn-ready certificate

Pass, then add it to LinkedIn in one click

No typing. The Add to LinkedIn button opens your profile’s Licenses & certifications form already filled in: the certificate name, Science of Apps as the issuer, the issue date, your credential ID and a link recruiters can use to verify it.

  1. 1Take the 20-minute test
  2. 2Score 70% or more
  3. 3Click Add to LinkedIn
Free · no sign-up · also emailed to you as a PDF
How it shows on your LinkedIn profile

See every Office & productivity certification and test →

Frequently asked questions

What is the Excel Test for Interview?

The Excel Test for Interview is a free intermediate-level, 20-minute skill test from Science of Apps. Practice for the Excel tests employers set in interviews — formulas and lookups such as SUMIFS and XLOOKUP, cleaning and analysing data, PivotTables and charts, and the shortcuts, error-fixing and good habits interviewers look for. Score 70% or more on its 20 questions to earn a verifiable Excel for Interviews certificate (SOA-XLI). Every question is based on published standards and research — including Excel functions (alphabetical) (Microsoft Support), Overview of PivotTables and PivotCharts (Microsoft Support), Available chart types in Office (Microsoft Support) — and each answer is explained with its source.

How do I take the Excel Test for Interview for free?

Read the four skill areas on this page, then take the 20-minute test online — no fee, course or sign-up. You see every answer explained when you finish. Score 70% or more and you get a Excel for Interviews certificate straight away, on screen, as a PDF and by email, with a credential ID anyone can verify.

Are the Excel Test for Interview questions based on real standards?

Yes. The questions are original scenarios written by Science of Apps, and each one is based on a public source you can read: Excel functions (alphabetical) (Microsoft Support); Overview of PivotTables and PivotCharts (Microsoft Support); Available chart types in Office (Microsoft Support); Dynamic array formulas and spilled array behaviour (Microsoft Support); XLOOKUP function (Microsoft Support); SUMIFS function (Microsoft Support). The source is shown under each question and linked in the answer review. Science of Apps doesn't copy questions from other tests.

What does the Excel Test for Interview cover?

Four skill areas with five questions each, drawn from a bank of 10 per area so a retake brings new questions: Formulas and Lookups (Cell references, Conditional functions and Lookups); Cleaning and Analysing Data (Text and date functions, Removing duplicates and Dynamic arrays and errors); PivotTables and Charts (Summarising data, Refreshing and grouping and Choosing charts); Interview Tasks and Good Practice (Shortcuts, Accuracy habits and What-if analysis). Every question is an original scenario based on a published standard, official documentation or research, named under the question.

Who should take the Excel Test for Interview?

Data analyst applicant, Financial analyst applicant, Operations applicant, Administrative applicant and Business analyst applicant. It suits anyone who wants a quick, verifiable way to show Excel Interview skills, from students and career switchers to experienced professionals.

Can I use this for Excel assessment test, Excel interview questions or Excel test practice?

Yes. The Excel Test for Interview is free and covers all of these: 20 scenario questions in 20 minutes, each answer explained with the source it comes from, so it works as interview and exam practice. It isn't a full course, so use the areas you miss as your study list. Scoring 70% or more earns a verifiable certificate.

Can I take the Excel Test for Interview from any country?

Yes. The test is online, in English and free everywhere — people take it from India, the US, the UK, Europe, Africa, Latin America and Asia-Pacific. Your certificate is dated with your own local date and can be verified from anywhere at scienceofapps.com/certification/verify/.

How long is the Excel Test for Interview?

20 questions — 5 from each of 4 skill areas — with a 20-minute limit. You need 70% (14 of 20) to pass and 90% for distinction.

How hard is the Excel Test for Interview?

We rate it Intermediate: assumes hands-on experience in the role. It has 20 scenario questions — 5 from each of 4 skill areas — and a 20-minute limit. You need 70% (14 of 20) to pass and 90% for distinction.

How much do Science of Apps certifications cost?

Nothing. There is no fee to take a test, to receive the certificate, to have it emailed or to verify it, and no sign-up.

How are the tests graded?

On our server, not in your browser. The answers never reach the page until you submit, so a certificate can only be earned by passing. Each certificate gets a unique credential ID stored by Science of Apps.

What happens if I don't pass?

You see your score for each area and every question with the correct answer and why, with the published source behind it. You can retake after 30 minutes, and the retake draws questions you haven't seen yet.

Do the certificates expire?

No. Every certificate is dated, so it always shows when you passed. Retake a test any time for a newer date or a higher score.

Can I add the certificate to LinkedIn?

Yes. After you pass, Add to LinkedIn opens the Licenses & certifications form with the certificate name, Science of Apps as the issuer, the issue date, your credential ID and the verification link filled in. You can also download it as a PDF or PNG, and it's emailed to you as a PDF.

How can an employer verify my certificate?

Every certificate has a credential ID and a QR code. Scanning it, or entering the ID at scienceofapps.com/certification/verify/, shows the holder's name, the certification, the score and the issue date from our records.

Are these accredited qualifications?

No. They are Science of Apps' own assessments of applied skill. They aren't issued by a university or standards body, and they work best alongside a portfolio that shows the skills in real work.

All free · no sign-up

990 more certifications to collect

Keep exploring

Read before you test

Pass it on

Challenge a friend or your team

Send them this test. It's free, takes minutes, and you can compare scores — every certificate can be verified.

Join free

Get the ideas, not the noise.

Sign up with Google and we’ll send you short UX psychology tips by email — why people tap, stall and leave, and what to do about it. Unsubscribe anytime. Prefer something to keep? Get the free Laws of UX guide as a PDF.

Get the free Laws of UX PDFFree · no spam · unsubscribe anytime
Free PDF · 74 pages · 2 editions

The Laws of UX, in one field guide

60 research-backed principles in 6 categories — what each one means, why it works on the human brain and how to use it on your own screens. Written by Sushant Singh, founder of Science of Apps, who has scaled consumer apps to lacs of users and spent 10+ years leading product across startups and digital businesses in the US, EU & India.

Pick your edition
Free PDF · 74 pages

Get Laws of UX by email

Choose your edition

You’ll also get occasional UX psychology tips. Unsubscribe anytime. Privacy policy

Free PDF · 90 pages · 2 editions

100+ Subscription Paywalls, decoded

110 real paywalls from top apps, taken apart, rated out of 5 and decoded with the Laws of UX — plus the frameworks, copy and checklists to ship your own. By Sushant Singh, founder of Science of Apps.

  • 110 paywalls rated
  • 34 Laws of UX
  • 12 frameworks

Which paywall scored 4.8 out of 5, and which scored 2.6? It’s all inside.

Pick your edition
Free PDF · 90 pages

Get 100+ Paywalls, Decoded by email

Choose your edition

You’ll also get occasional UX psychology tips. Unsubscribe anytime. Privacy policy