# Excel skills test

> A 15 minute pre-employment Excel test: SUM, AVERAGE, lookups, absolute references, IF, COUNTIF and pivot tables, with full screen and tab-switch detection.

URL: https://office.greatwork.company/quiz/templates/excel-skills-test
Last updated: 2026-11-21

A timed screening test of everyday spreadsheet skills for office, admin and operations roles.

## What's inside

- 10 questions: SUM, AVERAGE, VLOOKUP or XLOOKUP, absolute references, pivot tables, IF, freeze panes, COUNTIF, ##### errors, CSV limits
- 15 minute time limit, no going back, 60% pass mark
- Full screen, copy and paste blocked, computers only, auto-submit after 3 tab switches
- Score released by you, not shown to candidates when they finish

## How to use it

Add two or three questions using your own kind of data (a rent ledger, a stock sheet). Send it with email invites so each applicant gets one attempt on a personal link.

Pick it under New quiz, then Template, in Quiz: [Timed tests](https://office.greatwork.company/quiz/features/timed-tests) in [Office Quiz](https://office.greatwork.company/quiz).

---

Office by Great Work. Questions or corrections: hello@greatwork.company
