āļ—āļąāļāļĐāļ°āļ”āđ‰āļēāļ™āļ‹āļ­āļŸāļ•āđŒāđāļ§āļĢāđŒ

āđāļšāļšāļ—āļ”āļŠāļ­āļš Google Sheets āļŠāļģāļŦāļĢāļąāļšāļāļēāļĢāļˆāđ‰āļēāļ‡āļ‡āļēāļ™

See how candidates apply formulas, summarize data and keep shared sheets organized.

  • 10 āļ™āļēāļ—āļĩ
  • 15 āļ„āļģāļ–āļēāļĄ
  • āļĢāļ°āļ”āļąāļšāļāļĨāļēāļ‡
  • āļ›āļĢāļ™āļąāļĒ
  • āļ„āļģāļ–āļēāļĄāđ€āļ›āđ‡āļ™āļ āļēāļĐāļēāļ­āļąāļ‡āļāļĪāļĐ
  • āđƒāļŠāđ‰āđ„āļ”āđ‰āđ€āļ‰āļžāļēāļ°āļšāļ™āđ€āļ”āļŠāļāđŒāļ—āđ‡āļ­āļ›

āļ„āļģāļ•āļ­āļšāļŠāļąāđ‰āļ™āđ†

The Google Sheets test checks intermediate, everyday spreadsheet work in Google Sheets: math and statistics formulas, text, logic and lookup formulas, pivot tables and charts, and sorting, filtering and protecting shared data. Candidates answer 15 questions in 10 minutes on a computer. It suits analysts, finance, sales, marketing, HR, IT, operations and administration roles that work in shared spreadsheets.

āļ§āļąāļ”āļ­āļ°āđ„āļĢ

Practical skill with Google Sheets formulas, charts, pivot tables and data tools, read from sheet pictures.

Math and statistics formulas

Checks how candidates apply math and statistics formulas to values in a sheet.

Text, logic and lookup formulas

Checks text, logic and lookup formulas in everyday spreadsheet situations.

Tables and charts

Covers organizing information in tables and choosing or reading charts and pivot tables.

Sorting, filtering and protecting data

Covers sorting, filtering and protecting data to keep shared sheets organized.

āļĢāļđāļ›āđāļšāļšāļ„āļģāļ–āļēāļĄ

āļ›āļĢāļ™āļąāļĒ

āļœāļđāđ‰āļŠāļĄāļąāļ„āļĢ: āļ­āđˆāļēāļ™āļ‚āđ‰āļ­āļ„āļ§āļēāļĄāļŠāļąāđ‰āļ™ āđ† āļ•āļēāļĢāļēāļ‡ āļŦāļĢāļ·āļ­āļ‚āđ‰āļ­āļ„āļ§āļēāļĄ āđāļĨāđ‰āļ§āđ€āļĨāļ·āļ­āļāļ„āļģāļ•āļ­āļšāļ—āļĩāđˆāļ–āļđāļāļ•āđ‰āļ­āļ‡ āļŦāļĢāļ·āļ­āđ€āļĨāļ·āļ­āļāļ„āļģāļ•āļ­āļšāļ—āļĩāđˆāļ–āļđāļāļ•āđ‰āļ­āļ‡āļ—āļąāđ‰āļ‡āļŦāļĄāļ”

āļ„āļļāļ“āļˆāļ°āđ€āļŦāđ‡āļ™: āļœāļđāđ‰āļŠāļĄāļąāļ„āļĢāļĄāļĩāļ„āļ§āļēāļĄāļĢāļđāđ‰āđƒāļ™āđ€āļ™āļ·āđ‰āļ­āļŦāļēāļĄāļēāļāļžāļ­āļ—āļĩāđˆāļˆāļ°āļ™āļģāđ„āļ›āđƒāļŠāđ‰āđ„āļ”āđ‰āļŦāļĢāļ·āļ­āđ„āļĄāđˆ āđ„āļĄāđˆāđƒāļŠāđˆāđāļ„āđˆāļˆāļģāđ„āļ”āđ‰

āļ„āļģāļ–āļēāļĄ 15 āļ‚āđ‰āļ­ āđƒāļ™āđ€āļ§āļĨāļē 10 āļ™āļēāļ—āļĩ āđ‚āļ”āļĒāđāļŠāļ”āļ‡āļ—āļĩāļĨāļ°āļ‚āđ‰āļ­

āļšāļ—āļšāļēāļ—āļ‡āļēāļ™āļ—āļĩāđˆāđ€āļŦāļĄāļēāļ°āļāļąāļšāđāļšāļšāļ—āļ”āļŠāļ­āļšāļ™āļĩāđ‰

Roles that analyze or manage data in shared spreadsheets: data and business analysts, finance and accounting staff, sales and marketing teams, HR teams, IT staff, operations and administration roles.

What the Google Sheets test shows that a resume does not

  1. Formulas they can read

    Questions show a small sheet and ask what a math, statistics, text, logic or lookup formula returns, which a line on a resume cannot show.

  2. Summaries people can trust

    Pivot table and chart questions show whether a candidate picks a summary that answers the question asked.

  3. Care with shared data

    Sorting, filtering and protecting data matter most when several people work in one sheet. The test shows whether a candidate keeps shared data organized and clean.

āļŠāļīāđˆāļ‡āļ—āļĩāđˆāļ„āļļāļ“āļˆāļ°āđ„āļ”āđ‰āļĢāļąāļšāļŠāļģāļŦāļĢāļąāļšāļœāļđāđ‰āļŠāļĄāļąāļ„āļĢāđāļ•āđˆāļĨāļ°āļ„āļ™

āļ•āļąāļ§āļ­āļĒāđˆāļēāļ‡āļĢāļēāļĒāļ‡āļēāļ™ (āļ‚āđ‰āļ­āļĄāļđāļĨāļŠāļĄāļĄāļ•āļī)Google Sheets
83%āđ€āļ›āļ­āļĢāđŒāđ€āļ‹āđ‡āļ™āđ„āļ—āļĨāđŒ 73 āđ€āļāļ“āļ‘āđŒāļ­āđ‰āļēāļ‡āļ­āļīāļ‡: āļœāļđāđ‰āļŠāļĄāļąāļ„āļĢ HireValid āļˆāļģāļ™āļ§āļ™ 760 āļ„āļ™
Math and statistics formulas85%
Text, logic and lookup formulas74%
Tables and charts87%
Sorting, filtering and protecting data84%
Integrity Scoreāļ„āļ§āļēāļĄāļĄāļąāđˆāļ™āđƒāļˆāļŠāļđāļ‡
  • āļ­āļĒāļđāđˆāđƒāļ™āđāļ—āđ‡āļšāļ—āļ”āļŠāļ­āļšāļ•āļĨāļ­āļ”
  • āđ„āļĄāđˆāļĄāļĩāļ„āļģāļ•āļ­āļšāļ—āļĩāđˆāļ„āļąāļ”āļĨāļ­āļāđāļĨāļ°āļ§āļēāļ‡
  • āļ•āļ­āļšāļ”āđ‰āļ§āļĒāļ„āļ§āļēāļĄāđ€āļĢāđ‡āļ§āļŠāļĄāđˆāļģāđ€āļŠāļĄāļ­

āļ„āļ°āđāļ™āļ™ āđ‚āļ›āļĢāđ„āļŸāļĨāđŒ āđāļĨāļ°āļŠāļąāļāļāļēāļ“āļ”āđ‰āļēāļ™āļ„āļ§āļēāļĄāļ™āđˆāļēāđ€āļŠāļ·āđˆāļ­āļ–āļ·āļ­āđ€āļ›āđ‡āļ™āļ‚āđ‰āļ­āļĄāļđāļĨāļ›āļĢāļ°āļāļ­āļšāđƒāļŦāđ‰āļ„āļļāļ“āļžāļīāļˆāļēāļĢāļ“āļēāļĢāđˆāļ§āļĄāļāļąāļšāļāļēāļĢāļŠāļąāļĄāļ āļēāļĐāļ“āđŒ āđ„āļĄāđˆāđƒāļŠāđˆāļāļēāļĢāļ•āļąāļ”āļŠāļīāļ™āđƒāļˆāđ‚āļ”āļĒāļ­āļąāļ•āđ‚āļ™āļĄāļąāļ•āļī

āđƒāļŠāđ‰āđāļšāļšāļ—āļ”āļŠāļ­āļšāļ™āļĩāđ‰āļŸāļĢāļĩ

How the Google Sheets test resists AI help

Each candidate gets a different set of questions drawn from large pools, with question order and answer options shuffled. Questions arrive one at a time from the server, candidates cannot go back to an earlier question, and the answer keys never reach the browser.

Question text cannot be copied, and a blocked copy is recorded. Signals such as time away from the tab, pastes and very fast answers are summarized in an Integrity Score with a timeline for the employer to review. The score never decides anything about the candidate.

Use the score with a work sample and a structured interview

Read the result as evidence, never on its own, and look at the four sub-skill results as well as the total. For a hands-on check, give shortlisted candidates a short task in a shared sheet: a tracker with a few messy rows, a question that needs a summary or chart, and a range that other people should not be able to edit. Keep it to about 15 minutes so it mirrors the job without becoming unpaid work. Then ask every candidate the same questions in a structured interview.

Interview questions to ask after the Google Sheets test

  1. Several people edit the same sheet. How do you keep the data clean?

    Listen for protecting ranges that should not change, keeping one current version and agreeing how new rows are added.

  2. A manager asks for totals by month from a large sheet. How would you build it?

    Listen for a pivot table or formulas that update when data changes, and a check that the totals match the source.

  3. Tell me about a chart you made for someone else. Why did you choose that chart?

    Strong answers start from the question the reader needed answered, not from the chart type.

āļ„āļ§āļēāļĄāđ€āļ›āđ‡āļ™āļ˜āļĢāļĢāļĄāđāļĨāļ°āļāļēāļĢāļ›āļĢāļąāļšāđƒāļŦāđ‰āđ€āļŦāļĄāļēāļ°āļŠāļĄ

Sheets use everyday business data with no money symbols, dates written with the month as a word, and functions as they work in current Google Sheets with the United States locale. Each question shows the sheet or chart it asks about and states any menu action in words, so nothing depends on remembering a particular screen. The test asks for a computer so the sheets are large enough to read.

āļ„āļļāļ“āļŠāļēāļĄāļēāļĢāļ–āđƒāļŦāđ‰āđ€āļ§āļĨāļēāđ€āļžāļīāđˆāļĄāđ€āļ•āļīāļĄāđāļāđˆāļœāļđāđ‰āļŠāļĄāļąāļ„āļĢāļ„āļ™āđƒāļ”āļāđ‡āđ„āļ”āđ‰āđ€āļžāļ·āđˆāļ­āđ€āļ›āđ‡āļ™āļāļēāļĢāļ›āļĢāļąāļšāļ•āļēāļĄāļ„āļ§āļēāļĄāđ€āļŦāļĄāļēāļ°āļŠāļĄ āļœāļĨāļĨāļąāļžāļ˜āđŒāđ€āļ›āđ‡āļ™āļ‚āđ‰āļ­āļĄāļđāļĨāļ›āļĢāļ°āļāļ­āļšāļāļēāļĢāļžāļīāļˆāļēāļĢāļ“āļēāļ‚āļ­āļ‡āļšāļļāļ„āļ„āļĨ āđ„āļĄāđˆāđƒāļŠāđˆāļāļēāļĢāļ•āļąāļ”āļŠāļīāļ™āđƒāļˆāđ‚āļ”āļĒāļ­āļąāļ•āđ‚āļ™āļĄāļąāļ•āļī

Provisional: reliability is reported once 200 candidates have completed it.

āļ­āđˆāļēāļ™āđāļ™āļ§āļ—āļēāļ‡āļ”āđ‰āļēāļ™āļ„āļ§āļēāļĄāđ€āļ›āđ‡āļ™āļ˜āļĢāļĢāļĄāļ‚āļ­āļ‡āđ€āļĢāļē

āļĢāļēāļĒāļĨāļ°āđ€āļ­āļĩāļĒāļ”āđāļšāļšāļ—āļ”āļŠāļ­āļš

Short questions on everyday Google Sheets work at an intermediate level: math and statistics formulas; text, logic and lookup formulas; pivot tables and charts; and keeping shared data organized and clean. Most questions show a small sheet or chart and ask what a formula returns, what an action does to the data, or which approach fits the task.

  • āļ„āļģāļ–āļēāļĄāđ€āļ›āđ‡āļ™āļ āļēāļĐāļēāļ­āļąāļ‡āļāļĪāļĐ
  • āđ„āļĄāđˆāļˆāļģāđ€āļ›āđ‡āļ™āļ•āđ‰āļ­āļ‡āđƒāļŠāđ‰āļ­āļļāļ›āļāļĢāļ“āđŒāļŠāđˆāļ§āļĒāđƒāļ”āđ†
  • āļ•āļ­āļšāļ„āļģāļ–āļēāļĄāđāļ•āđˆāļĨāļ°āļ‚āđ‰āļ­āđ„āļ”āđ‰āđ€āļžāļĩāļĒāļ‡āļ„āļĢāļąāđ‰āļ‡āđ€āļ”āļĩāļĒāļ§āļ•āļēāļĄāļĨāļģāļ”āļąāļš āđāļĨāļ°āļĒāđ‰āļ­āļ™āļāļĨāļąāļšāđ„āļ›āđ„āļĄāđˆāđ„āļ”āđ‰
  • āļ„āļģāļ–āļēāļĄāļāļķāļāļŦāļąāļ” 4 āļ‚āđ‰āļ­ āđƒāļŠāđ‰āđ€āļ§āļĨāļē 4 āļ™āļēāļ—āļĩāļāđˆāļ­āļ™āđ€āļĢāļīāđˆāļĄāđāļšāļšāļ—āļ”āļŠāļ­āļšāļˆāļąāļšāđ€āļ§āļĨāļē
  • āļ—āļģāđāļšāļšāļ—āļ”āļŠāļ­āļšāļšāļ™āļ„āļ­āļĄāļžāļīāļ§āđ€āļ•āļ­āļĢāđŒāļ•āļąāđ‰āļ‡āđ‚āļ•āđŠāļ°āļŦāļĢāļ·āļ­āđāļĨāđ‡āļ›āļ—āđ‡āļ­āļ›

Google Sheets āđ€āļ›āđ‡āļ™āđ€āļ„āļĢāļ·āđˆāļ­āļ‡āļŦāļĄāļēāļĒāļāļēāļĢāļ„āđ‰āļēāļ‚āļ­āļ‡āđ€āļˆāđ‰āļēāļ‚āļ­āļ‡āđ€āļ„āļĢāļ·āđˆāļ­āļ‡āļŦāļĄāļēāļĒāļ”āļąāļ‡āļāļĨāđˆāļēāļ§ HireValid āđ„āļĄāđˆāļĄāļĩāļŠāđˆāļ§āļ™āđ€āļāļĩāđˆāļĒāļ§āļ‚āđ‰āļ­āļ‡āļŦāļĢāļ·āļ­āđ„āļ”āđ‰āļĢāļąāļšāļāļēāļĢāļĢāļąāļšāļĢāļ­āļ‡āļˆāļēāļāđ€āļˆāđ‰āļēāļ‚āļ­āļ‡āđ€āļ„āļĢāļ·āđˆāļ­āļ‡āļŦāļĄāļēāļĒāļ™āļĩāđ‰

āļ„āļģāļ–āļēāļĄāļ—āļĩāđˆāļžāļšāļšāđˆāļ­āļĒ

What is on the Google Sheets test?+

Fifteen single-choice and multiple-select questions in 10 minutes on four areas: math and statistics formulas; text, logic and lookup formulas; tables and charts, including pivot tables; and sorting, filtering and protecting data. Most questions show a small sheet or chart and ask what a formula returns, what an action does or which approach fits the task.

Can someone who knows Excel do well on the Google Sheets test?+

Often, because many everyday formulas work in a similar way in both tools. The test uses functions as they work in current Google Sheets with the United States locale, and it states any menu action in words, so nothing depends on remembering a particular screen.

Does the Google Sheets test cover Google Docs, Gmail or Calendar?+

No. It is a test of spreadsheet work in Google Sheets. If the role depends on documents or email, the test library holds separate tests such as Google Docs and Email with Gmail, which you can add to the same assessment.

Can candidates take the Google Sheets test on a phone?+

No. The test asks for a computer so the sheets are large enough to read. Say so in the invitation, and offer another arrangement to any candidate without access to a desktop or laptop.

āđāļšāļšāļ—āļ”āļŠāļ­āļšāļ—āļĩāđˆāđ€āļāļĩāđˆāļĒāļ§āļ‚āđ‰āļ­āļ‡

āļ—āļąāļāļĐāļ°āļ”āđ‰āļēāļ™āļ‹āļ­āļŸāļ•āđŒāđāļ§āļĢāđŒ

āļ‡āļēāļ™āđƒāļ™ Google Sheets

60 āļ™āļēāļ—āļĩ, āļ—āļąāļāļĐāļ°āļ”āđ‰āļēāļ™āļ‹āļ­āļŸāļ•āđŒāđāļ§āļĢāđŒ

āļ”āļđāđ€āļžāļīāđˆāļĄāđ€āļ•āļīāļĄ
āļ—āļąāļāļĐāļ°āļ”āđ‰āļēāļ™āļ‹āļ­āļŸāļ•āđŒāđāļ§āļĢāđŒ

Microsoft Excel āļĢāļ°āļ”āļąāļšāļāļĨāļēāļ‡

10 āļ™āļēāļ—āļĩ, āļ—āļąāļāļĐāļ°āļ”āđ‰āļēāļ™āļ‹āļ­āļŸāļ•āđŒāđāļ§āļĢāđŒ

āļ”āļđāđ€āļžāļīāđˆāļĄāđ€āļ•āļīāļĄ
āļ—āļąāļāļĐāļ°āļ”āđ‰āļēāļ™āļ‹āļ­āļŸāļ•āđŒāđāļ§āļĢāđŒ

Microsoft Word

12 āļ™āļēāļ—āļĩ, āļ—āļąāļāļĐāļ°āļ”āđ‰āļēāļ™āļ‹āļ­āļŸāļ•āđŒāđāļ§āļĢāđŒ

āļ”āļđāđ€āļžāļīāđˆāļĄāđ€āļ•āļīāļĄ
āļ—āļąāļāļĐāļ°āļ”āđ‰āļēāļ™āļ‹āļ­āļŸāļ•āđŒāđāļ§āļĢāđŒ

Google Docs

10 āļ™āļēāļ—āļĩ, āļ—āļąāļāļĐāļ°āļ”āđ‰āļēāļ™āļ‹āļ­āļŸāļ•āđŒāđāļ§āļĢāđŒ

āļ”āļđāđ€āļžāļīāđˆāļĄāđ€āļ•āļīāļĄ
āļ—āļąāļāļĐāļ°āļ”āđ‰āļēāļ™āļ‹āļ­āļŸāļ•āđŒāđāļ§āļĢāđŒ

Microsoft PowerPoint

10 āļ™āļēāļ—āļĩ, āļ—āļąāļāļĐāļ°āļ”āđ‰āļēāļ™āļ‹āļ­āļŸāļ•āđŒāđāļ§āļĢāđŒ

āļ”āļđāđ€āļžāļīāđˆāļĄāđ€āļ•āļīāļĄ
āļ—āļąāļāļĐāļ°āļ”āđ‰āļēāļ™āļ‹āļ­āļŸāļ•āđŒāđāļ§āļĢāđŒ

Microsoft 365

11 āļ™āļēāļ—āļĩ, āļ—āļąāļāļĐāļ°āļ”āđ‰āļēāļ™āļ‹āļ­āļŸāļ•āđŒāđāļ§āļĢāđŒ

āļ”āļđāđ€āļžāļīāđˆāļĄāđ€āļ•āļīāļĄ

āđƒāļŠāđ‰āđāļšāļšāļ—āļ”āļŠāļ­āļš Google Sheets āđƒāļ™āļāļēāļĢāļˆāđ‰āļēāļ‡āļ‡āļēāļ™āļ„āļĢāļąāđ‰āļ‡āļ•āđˆāļ­āđ„āļ›

āļ—āļļāļāđāļžāđ‡āļāđ€āļāļˆ āļĢāļ§āļĄāļ–āļķāļ‡ Free āļĄāļĩāļ„āļĨāļąāļ‡āđāļšāļšāļ—āļ”āļŠāļ­āļšāļ„āļĢāļšāļ—āļąāđ‰āļ‡āļŦāļĄāļ”

āđƒāļŠāđ‰āđāļšāļšāļ—āļ”āļŠāļ­āļšāļ™āļĩāđ‰āļŸāļĢāļĩāđāļžāđ‡āļāđ€āļāļˆ Free āđ„āļĄāđˆāļ•āđ‰āļ­āļ‡āđƒāļŠāđ‰āļšāļąāļ•āļĢāđ€āļ„āļĢāļ”āļīāļ•
āđāļžāđ‡āļāđ€āļāļˆ Free āđ„āļĄāđˆāļ•āđ‰āļ­āļ‡āđƒāļŠāđ‰āļšāļąāļ•āļĢāđ€āļ„āļĢāļ”āļīāļ•āđƒāļŠāđ‰āđāļšāļšāļ—āļ”āļŠāļ­āļšāļ™āļĩāđ‰āļŸāļĢāļĩ

āđ€āļāļĩāđˆāļĒāļ§āļāļąāļšāļ—āļĩāļĄāļšāļĢāļĢāļ“āļēāļ˜āļīāļāļēāļĢ

āđ€āļ‚āļĩāļĒāļ™āđāļĨāļ°āļ•āļĢāļ§āļˆāļŠāļ­āļšāļ‚āđ‰āļ­āđ€āļ—āđ‡āļˆāļˆāļĢāļīāļ‡āđ‚āļ”āļĒāļ—āļĩāļĄāļšāļĢāļĢāļ“āļēāļ˜āļīāļāļēāļĢāļ‚āļ­āļ‡ HireValid āđāļŦāļĨāđˆāļ‡āļ‚āđ‰āļ­āļĄāļđāļĨāļ—āļĩāđˆāļ•āļĢāļ§āļˆāļŠāļ­āļšāđāļĨāđ‰āļ§ . āļ­āđˆāļēāļ™āļ™āđ‚āļĒāļšāļēāļĒāļ”āđ‰āļēāļ™āļšāļĢāļĢāļ“āļēāļ˜āļīāļāļēāļĢ