Google Sheets: practice, test and prove it

Formulas, lookups, FILTER, UNIQUE, QUERY, IMPORTRANGE, sharing, data validation and version history.

FreeNo sign-up to testNo attempts yet

Start the google sheets test Read the first lesson

Screenings for Google Sheets usually mix short formula questions with practical situations: a lookup that returns #N/A, a shared file someone broke, a list that needs duplicates removed, or data that lives in another spreadsheet. Clients hiring virtual assistants want to know you can keep a shared sheet clean without supervision.

This page gives you a 15-question practice set, two lessons on the formulas and sharing habits that come up most, and interview answers you can adapt. Work through the questions first, then read the lesson for anything you missed.

Benchmark: The pass mark is 80%, and Google Sheets is commonly screened for remote admin, virtual assistant and operations support roles. Requirements vary by employer.

Lessons

Lookups, FILTER and UNIQUE in Google SheetsHow VLOOKUP, XLOOKUP, FILTER and UNIQUE work, and the small mistakes that make them return the wrong result.Lesson 1

Sharing, IMPORTRANGE and keeping a shared sheet safeSharing roles, protected ranges, filter views, data validation, IMPORTRANGE and version history for shared work.Lesson 2

The QUERY function: SQL-style questions on a sheetHow to select, filter, sort and group with QUERY, and the column-letter and quoting mistakes that cause errors.Lesson 3

ARRAYFORMULA, SPLIT and cleaning text in Google SheetsHow to fill a whole column with one formula, split and trim messy text, and fix numbers stored as text before they break totals.Lesson 4

Interview prep

Google Sheets interview questionsQuestions clients and hiring managers ask when a role depends on shared spreadsheets, with answers you can adapt.6 questions

Certificate

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

Common questions

Is Google Sheets tested differently from Excel?

The core formulas are similar, but Sheets screenings lean more on sharing, IMPORTRANGE, QUERY and live collaboration features. Expect questions about who can see or edit a file.

Do I need to know Apps Script?

Not for most admin and assistant screenings. Formulas, data validation, protected ranges and version history matter far more at this level.

How should I practise?

Recreate a real task, such as a lead list or an expense tracker, in a blank sheet. Writing formulas from memory teaches more than reading about them.

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