рд╕реЙрдлреНрдЯрд╡реЗрдЕрд░ рдХреМрд╢рд▓реНрдпреЗ

Google Sheets tasks test for hiring

See how candidates work through practical spreadsheet tasks in a live sheet.

  • 60 рдорд┐рдирд┐рдЯреЗ
  • 6 рдкреНрд░рд╢реНрди
  • рдордзреНрдпрдо
  • рд╕реНрдкреНрд░реЗрдбрд╢реАрдЯрдордзреАрд▓ рдХрд╛рдореЗ
  • рдЗрдВрдЧреНрд░рдЬреА рдордзреАрд▓ рдкреНрд░рд╢реНрди
  • рдлрдХреНрдд рдбреЗрд╕реНрдХрдЯреЙрдк

рдереЛрдбрдХреНрдпрд╛рдд рдЙрддреНрддрд░

The Google Sheets Tasks test is an intermediate hiring assessment for office and administrative staff, project coordinators, sales operations, purchasing, HR administration, and other roles that maintain spreadsheets. Candidates complete hands-on tasks in a working sheet, showing how they use formulas, sorting, lookups, conditional logic, and pivot-style summaries.

рд╣реЗ рдХрд╛рдп рдореЛрдЬрддреЗ

Practical spreadsheet skill: formulas, sorting, lookups, conditional logic and pivot-style summaries, done in a working sheet.

Basic formulas

Candidates use basic formulas in a live sheet, with each task scored on the values in named cells.

Sorting records

Candidates sort records into the order required by the task.

Lookup formulas

Candidates use lookup formulas to work with information in the sheet.

Conditional formulas

Candidates apply conditional formulas to the spreadsheet task.

Pivot-style summaries

Candidates build pivot-style summaries with row and column groups, sums, counts, averages, filters, and grand totals.

рдкреНрд░рд╢реНрдирд╛рдВрдЪреЗ рдкреНрд░рдХрд╛рд░

рд╕реНрдкреНрд░реЗрдбрд╢реАрдЯрдордзреАрд▓ рдХрд╛рдореЗ

рдЙрдореЗрджрд╡рд╛рд░: рдПрдЦрд╛рджреЗ рдХрд╛рдо рдкреВрд░реНрдг рдХрд░рдгреНрдпрд╛рд╕рд╛рдареА рдЫреЛрдЯреНрдпрд╛ рд╕реНрдкреНрд░реЗрдбрд╢реАрдЯрдордзреАрд▓ рд╕реЗрд▓рдордзреНрдпреЗ рдореВрд▓реНрдпреЗ рдХрд┐рдВрд╡рд╛ рд╕реВрддреНрд░реЗ рднрд░рддреЛ.

рддреБрдореНрд╣рд╛рд▓рд╛ рджрд┐рд╕рддреЗ: рд╕реНрдкреНрд░реЗрдбрд╢реАрдЯрдордзреАрд▓ рдкреНрд░рддреНрдпрдХреНрд╖ рдХрд╛рдо. рд╕реВрддреНрд░рд╛рдВрдордзреВрди рдорд┐рд│рдгрд╛рд▒реНрдпрд╛ рдирд┐рдХрд╛рд▓рд╛рдВрд╡рд░ рдЧреБрдгрд╛рдВрдХрди рдХреЗрд▓реЗ рдЬрд╛рддреЗ.

60 рдорд┐рдирд┐рдЯрд╛рдВрдд 6 рдкреНрд░рд╢реНрди, рдПрдХрд╛ рд╡реЗрд│реА рдПрдХ рдкреНрд░рд╢реНрди рджрд┐рд▓рд╛ рдЬрд╛рддреЛ.

рд╣реА рдЪрд╛рдЪрдгреА рд▓рд╛рдЧреВ рд╣реЛрдгрд╛рд▒реНрдпрд╛ рднреВрдорд┐рдХрд╛

Office and administrative staff, project coordinators, sales operations, purchasing and HR administration, market research and other roles that build and maintain spreadsheets day to day.

What this test can show

  1. Check formulas in use

    Candidates enter formulas in a working sheet, and scoring reflects the values produced in the cells each task names.

  2. Review summary building

    See whether a candidate can produce grouped sums, counts, averages, filters, and grand totals in a pivot-style summary.

  3. Use clear task rules

    Each task states every rule its answer depends on, while the data uses plain numbers and dates written to avoid misreading.

  4. Matches Google Sheets syntax

    The sheet uses the same formula syntax as Google Sheets, so candidates who already work in Google Sheets write formulas the way they do on the job.

рдкреНрд░рддреНрдпреЗрдХ рдЙрдореЗрджрд╡рд╛рд░рд╛рд╕рд╛рдареА рддреБрдореНрд╣рд╛рд▓рд╛ рдХрд╛рдп рдорд┐рд│рддреЗ

рдЙрджрд╛рд╣рд░рдгрд╛рд░реНрде рдЕрд╣рд╡рд╛рд▓ (рдХрд╛рд▓реНрдкрдирд┐рдХ рдбреЗрдЯрд╛)Google Sheets рдордзреАрд▓ рдХрд╛рдореЗ
ренреи%рдкрд░реНрд╕реЗрдВрдЯрд╛рдЗрд▓ 48. рдмреЗрдВрдЪрдорд╛рд░реНрдХ: HireValid рдЙрдореЗрджрд╡рд╛рд░, n = рекрепрек
Basic formulasрелрем%
Sorting recordsремрен%
Lookup formulasреорем%
Conditional formulasремрез%
Pivot-style summariesреорео%
Integrity ScoreрдЙрдЪреНрдЪ рд╡рд┐рд╢реНрд╡рд╛рд╕рдкрд╛рддрд│реА
  • рд╕рдВрдкреВрд░реНрдг рдЪрд╛рдЪрдгреАрджрд░рдореНрдпрд╛рди рдЪрд╛рдЪрдгреАрдЪрд╛ рдЯреЕрдм рдЙрдШрдбрд╛ рдареЗрд╡рд▓рд╛
  • рдкреЗрд╕реНрдЯ рдХреЗрд▓реЗрд▓реА рдЙрддреНрддрд░реЗ рдирд╛рд╣реАрдд
  • рд╕реНрдерд┐рд░ рдЧрддреАрдиреЗ рдЙрддреНрддрд░реЗ рджрд┐рд▓реА

рд╕реНрдХреЛрдЕрд░, рдкреНрд░реЛрдлрд╛рдЗрд▓ рдЖрдгрд┐ Integrity Score рдордзреАрд▓ рд╕рдВрдХреЗрдд рд╣реЗ рдореБрд▓рд╛рдЦрддреАрд╕реЛрдмрдд рддреБрдореНрд╣реА рддрдкрд╛рд╕рдгреНрдпрд╛рд╕рд╛рдареАрдЪреЗ рдкреБрд░рд╛рд╡реЗ рдЖрд╣реЗрдд; рддреЗ рдХрдзреАрд╣реА рд╕реНрд╡рдпрдВрдЪрд▓рд┐рдд рдирд┐рд░реНрдгрдпрд╛рдЪрд╛ рдЖрдзрд╛рд░ рдирд╕рддрд╛рдд.

рд╣реА рдЯреЗрд╕реНрдЯ рд╡рд┐рдирд╛рдореВрд▓реНрдп рд╡рд╛рдкрд░рд╛

How the test supports review

Each candidate gets a different question set from large pools, and questions appear in a different order. The browser shows one question at a time, and candidates cannot go back. Server timing means a reload restores the same question with only the remaining time. Question text cannot be selected or copied; blocked copy attempts are recorded. HireValid records signals such as time away from the test tab and pastes into answers, then summarizes them in an Integrity Score with an evidence timeline for employer review. It does not decide on its own. With candidate consent, an employer can add webcam photos at random moments. Learn more about how we build our tests and the Google Sheets test.

Use the score as evidence

Review the score alongside a spreadsheet work sample connected to the role and a structured interview with the same job-related questions for each candidate. The score is one source of evidence for your review, not a decision by itself. See our pre-employment testing guide for more on using assessments in hiring.

Structured interview questions

  1. Tell me how you would organize a sheet of incoming records for a weekly review.

    Listen for a clear account of sorting records into a required order and checking that the resulting sheet meets the task's needs.

  2. Describe a spreadsheet summary you have built to help someone review information.

    Listen for how they grouped information and chose sums, counts, averages, filters, or grand totals to serve the work.

  3. Walk me through how you would use a spreadsheet to connect related records.

    Listen for a relevant example of using lookup formulas and checking that the resulting values are useful.

рдирд┐рд╖реНрдкрдХреНрд╖рддрд╛ рдЖрдгрд┐ рдЖрд╡рд╢реНрдпрдХ рд╕реБрд╡рд┐рдзрд╛

Sheets use everyday business data with plain numbers and no money symbols, dates written so they cannot be misread, and names from many backgrounds. Tasks need only functions that behave the same in Google Sheets and HireValid's sheet with US settings, the task text states every rule the answer depends on, and the test asks for a computer so the sheets are large enough to work in.

рд╕реЛрдпреАрд╕рд╛рдареА рддреБрдореНрд╣реА рдХреЛрдгрддреНрдпрд╛рд╣реА рдЙрдореЗрджрд╡рд╛рд░рд╛рд▓рд╛ рдЕрддрд┐рд░рд┐рдХреНрдд рд╡реЗрд│ рджреЗрдК рд╢рдХрддрд╛. рдирд┐рдХрд╛рд▓ рд╣реЗ рдПрдЦрд╛рджреНрдпрд╛ рд╡реНрдпрдХреНрддреАрдиреЗ рддрдкрд╛рд╕рдгреНрдпрд╛рд╕рд╛рдареАрдЪреЗ рдкреБрд░рд╛рд╡реЗ рдЖрд╣реЗрдд, рд╕реНрд╡рдпрдВрдЪрд▓рд┐рдд рдирд┐рд░реНрдгрдпрд╛рдЪрд╛ рдЖрдзрд╛рд░ рдирд╛рд╣реАрдд.

Provisional: no norms exist yet, and reliability is reported once 200 candidates have completed it.

рдирд┐рд╖реНрдкрдХреНрд╖рддреЗрдмрд╛рдмрддрдЪрд╛ рдЖрдордЪрд╛ рджреГрд╖реНрдЯрд┐рдХреЛрди рд╡рд╛рдЪрд╛

рдЪрд╛рдЪрдгреАрдЪреЗ рддрдкрд╢реАрд▓

Six hands-on spreadsheet tasks at an intermediate level, worked in a live sheet: basic formulas, sorting records into a required order, lookup formulas, conditional formulas, and building the summaries a pivot table produces (row and column groups, sums, counts, averages, filters and grand totals). Tasks run in HireValid's own spreadsheet, which uses the same formula syntax as Google Sheets, and each task is scored on the values in the cells it names.

  • рдкреНрд░рд╢реНрди рдЗрдВрдЧреНрд░рдЬреАрдордзреНрдпреЗ рдЖрд╣реЗрдд.
  • рдХреЛрдгрддреНрдпрд╛рд╣реА рд╕рд╣рд╛рдпреНрдпрдХ рд╕рд╛рдзрдирд╛рдВрдЪреА рдЧрд░рдЬ рдирд╛рд╣реА.
  • рдкреНрд░рддреНрдпреЗрдХ рдкреНрд░рд╢реНрдирд╛рдЪреЗ рдЙрддреНрддрд░ рдХреНрд░рдорд╛рдиреЗ рдПрдХрджрд╛рдЪ рджреЗрддрд╛ рдпреЗрддреЗ. рдорд╛рдЧреАрд▓ рдкреНрд░рд╢реНрдирд╛рдХрдбреЗ рдкрд░рдд рдЬрд╛рддрд╛ рдпреЗрдд рдирд╛рд╣реА.
  • рд╡реЗрд│реЗрдЪреНрдпрд╛ рдорд░реНрдпрд╛рджреЗрддреАрд▓ рдЯреЗрд╕реНрдЯрдкреВрд░реНрд╡реА 1 рд╕рд░рд╛рд╡ рдЯрд╛рд╕реНрдХ, 10 рдорд┐рдирд┐рдЯреЗ.
  • рдбреЗрд╕реНрдХрдЯреЙрдк рдХрд┐рдВрд╡рд╛ рд▓реЕрдкрдЯреЙрдк рд╕рдВрдЧрдгрдХрд╛рд╡рд░ рджрд┐рд▓реА рдЬрд╛рддреЗ.

Google Sheets рд╣рд╛ рддреНрдпрд╛рдЪреНрдпрд╛ рдорд╛рд▓рдХрд╛рдЪрд╛ рдЯреНрд░реЗрдбрдорд╛рд░реНрдХ рдЖрд╣реЗ. HireValid рддреНрдпрд╛рдЪреНрдпрд╛рд╢реА рд╕рдВрд▓рдЧреНрди рдирд╛рд╣реА рдХрд┐рдВрд╡рд╛ рддреНрдпрд╛рдЪреЗ рд╕рдорд░реНрдерди рдкреНрд░рд╛рдкреНрдд рдирд╛рд╣реА.

рд╡рд╛рд░рдВрд╡рд╛рд░ рд╡рд┐рдЪрд╛рд░рд▓реЗ рдЬрд╛рдгрд╛рд░реЗ рдкреНрд░рд╢реНрди

How does the Google Sheets Tasks test handle fairness?+

Tasks use everyday business data with plain numbers, unambiguous dates and names from many backgrounds. The test requires a computer so the sheets can be large enough to work in.

What practice and timing are included with the Google Sheets Tasks test?+

The practice set has one question and takes 10 minutes. The assessment has six hands-on spreadsheet tasks and takes 60 minutes. Use the practice set to familiarize candidates with the task format.

What tools can candidates use during the Google Sheets Tasks test?+

No aids are allowed. The test is desktop-only, and candidates work in HireValid's spreadsheet, which uses the same formula syntax as Google Sheets. Each task is scored on the values in the cells it names, and candidates cannot return to an earlier task.

Which roles and level fit the Google Sheets Tasks test?+

It is an intermediate assessment for office and administrative staff, project coordinators, sales operations, purchasing, and HR administration. It may also fit an [Office Administrator](/roles/office-administrator) role that maintains spreadsheets day to day.

Does the Google Sheets Tasks test rely on functions that differ between spreadsheet tools?+

No. Tasks need only functions that behave the same in Google Sheets and in HireValid's sheet with US settings. The task text states every rule the answer depends on, so candidates are not marked down for a setting or a function their usual tool handles differently.

рд╕рдВрдмрдВрдзрд┐рдд рдЪрд╛рдЪрдгреНрдпрд╛

рд╕реЙрдлреНрдЯрд╡реЗрдЕрд░ рдХреМрд╢рд▓реНрдпреЗ

Google Sheets

10 рдорд┐рдирд┐рдЯреЗ, рд╕реЙрдлреНрдЯрд╡реЗрдЕрд░ рдХреМрд╢рд▓реНрдпреЗ

рдПрдХреНрд╕рдкреНрд▓реЛрд░ рдХрд░рд╛
рд╕реЙрдлреНрдЯрд╡реЗрдЕрд░ рдХреМрд╢рд▓реНрдпреЗ

Microsoft Excel рдордзреНрдпрдо

10 рдорд┐рдирд┐рдЯреЗ, рд╕реЙрдлреНрдЯрд╡реЗрдЕрд░ рдХреМрд╢рд▓реНрдпреЗ

рдПрдХреНрд╕рдкреНрд▓реЛрд░ рдХрд░рд╛
рд╕реЙрдлреНрдЯрд╡реЗрдЕрд░ рдХреМрд╢рд▓реНрдпреЗ

Microsoft Word

12 рдорд┐рдирд┐рдЯреЗ, рд╕реЙрдлреНрдЯрд╡реЗрдЕрд░ рдХреМрд╢рд▓реНрдпреЗ

рдПрдХреНрд╕рдкреНрд▓реЛрд░ рдХрд░рд╛
рд╕реЙрдлреНрдЯрд╡реЗрдЕрд░ рдХреМрд╢рд▓реНрдпреЗ

Google Docs

10 рдорд┐рдирд┐рдЯреЗ, рд╕реЙрдлреНрдЯрд╡реЗрдЕрд░ рдХреМрд╢рд▓реНрдпреЗ

рдПрдХреНрд╕рдкреНрд▓реЛрд░ рдХрд░рд╛
рд╕реЙрдлреНрдЯрд╡реЗрдЕрд░ рдХреМрд╢рд▓реНрдпреЗ

Microsoft 365

11 рдорд┐рдирд┐рдЯреЗ, рд╕реЙрдлреНрдЯрд╡реЗрдЕрд░ рдХреМрд╢рд▓реНрдпреЗ

рдПрдХреНрд╕рдкреНрд▓реЛрд░ рдХрд░рд╛
рд╕реЙрдлреНрдЯрд╡реЗрдЕрд░ рдХреМрд╢рд▓реНрдпреЗ

Microsoft PowerPoint

10 рдорд┐рдирд┐рдЯреЗ, рд╕реЙрдлреНрдЯрд╡реЗрдЕрд░ рдХреМрд╢рд▓реНрдпреЗ

рдПрдХреНрд╕рдкреНрд▓реЛрд░ рдХрд░рд╛

рддреБрдордЪреНрдпрд╛ рдкреБрдвреАрд▓ рднрд░рддреАрд╕рд╛рдареА Google Sheets рдордзреАрд▓ рдХрд╛рдореЗ рдЯреЗрд╕реНрдЯ рд╡рд╛рдкрд░рд╛

Free рд╕рд╣рд┐рдд рдкреНрд░рддреНрдпреЗрдХ рдкреНрд▓реЕрдирдордзреНрдпреЗ рд╕рдВрдкреВрд░реНрдг рдЯреЗрд╕реНрдЯ рд▓рд╛рдпрдмреНрд░рд░реА рдЙрдкрд▓рдмреНрдз рдЖрд╣реЗ.

рд╣реА рдЯреЗрд╕реНрдЯ рд╡рд┐рдирд╛рдореВрд▓реНрдп рд╡рд╛рдкрд░рд╛Free рдкреНрд▓реЕрди. рдХреНрд░реЗрдбрд┐рдЯ рдХрд╛рд░реНрдбрдЪреА рдЧрд░рдЬ рдирд╛рд╣реА.
Free рдкреНрд▓реЕрди. рдХреНрд░реЗрдбрд┐рдЯ рдХрд╛рд░реНрдбрдЪреА рдЧрд░рдЬ рдирд╛рд╣реА.рд╣реА рдЯреЗрд╕реНрдЯ рд╡рд┐рдирд╛рдореВрд▓реНрдп рд╡рд╛рдкрд░рд╛

рд╕рдВрдкрд╛рджрдХреАрдп рдЯреАрдордмрджреНрджрд▓

HireValid editorial team рдиреЗ рд▓рд┐рд╣рд┐рд▓реЗрд▓реЗ рдЖрдгрд┐ рддрдереНрдпрд╛рдВрдЪреА рдкрдбрддрд╛рд│рдгреА рдХреЗрд▓реЗрд▓реЗ. рддрдкрд╛рд╕рд▓реЗрд▓реЗ рд╕реНрд░реЛрдд . рд╕рдВрдкрд╛рджрдХреАрдп рдзреЛрд░рдг рд╡рд╛рдЪрд╛.