Free online assessment

Assess your Google Sheets skills for free

45-question technical assessment drawn from a 72-question bank to place a learner in Google Sheets and recommend the most useful training modules.

This assessment measures knowledge and produces a practical diagnostic. Modules are recommended after the test; they are not an offer of paid courses.

Start for free How does the test work?

What is assessed

Questions about practical workplace skills

The test covers different areas of the software, including beginner, intermediate and advanced questions. The score and skill-area breakdown help reveal strengths and topics to revisit.

This is not an official certification and should not be the sole factor in an employment decision.

Who can use it

Google Sheets analyst

Employees and applicants.
HR professionals.
Employers, managers and team leads.

Assessment learning framework

Modules that may appear in your recommended plan

The topics below form the recommendation framework associated with this assessment. The system selects priorities using individual answers and proposes a plan to use independently with a provider of your choice. We do not deliver these courses through this website.

Topic M01

Sheets, ranges and formatting

Keep headers visible while scrolling through a large table • Give a readable name to a range to simplify references • Automatically change a cell’s appearance based on its value

Keep headers visible while scrolling through a large table
Give a readable name to a range to simplify references
Automatically change a cell’s appearance based on its value
Quickly apply row banding to improve readability
Apply a structured workflow for sheets, ranges and formatting

3 h

Topic M02

Formulas and references

Lock both column and row when copying a formula • Return a different result depending on whether a condition is true or false • Sum values that meet one or more criteria

Lock both column and row when copying a formula
Return a different result depending on whether a condition is true or false
Sum values that meet one or more criteria
Count cells that meet one or more criteria
Apply a structured workflow for formulas and references

3 h

Topic M03

Sorting, filtering and data quality

Temporarily show only rows matching selected criteria • Apply your own filter without disrupting other collaborators’ views • Restrict or guide the values allowed in a cell

Temporarily show only rows matching selected criteria
Apply your own filter without disrupting other collaborators’ views
Restrict or guide the values allowed in a cell
Remove repeated rows based on selected columns
Apply a structured workflow for sorting, filtering and data quality

3 h

Topic M04

Lookup, extraction and dynamic arrays

Look up a key in a range and return a corresponding value • Perform a flexible lookup by separating result position from key matching • Dynamically return only rows that meet a condition

Look up a key in a range and return a corresponding value
Perform a flexible lookup by separating result position from key matching
Dynamically return only rows that meet a condition
Query a range with selection, filtering, grouping and aggregation
Apply a structured workflow for lookup, extraction and dynamic arrays

3 h

Topic M05

Pivot tables, charts and analysis

Quickly summarize a dataset by categories and measures • Provide a visual control for filtering a pivot table or range • Choose a chart type and configure series, axes and presentation

Quickly summarize a dataset by categories and measures
Provide a visual control for filtering a pivot table or range
Choose a chart type and configure series, axes and presentation
Add a derived calculation inside a pivot table
Apply a structured workflow for pivot tables, charts and analysis

3 h

Topic M06

Collaboration and protection

Limit who can edit selected cells or sheets • View or restore an earlier state of the spreadsheet • Draw a collaborator’s attention to a cell and leave follow-up context

Limit who can edit selected cells or sheets
View or restore an earlier state of the spreadsheet
Draw a collaborator’s attention to a cell and leave follow-up context
Receive alerts for selected changes to the file
Apply a structured workflow for collaboration and protection

3 h

Topic M07

Advanced functions and dynamic calculations

Apply a calculation to multiple rows or cells with one formula • Name intermediate values inside a formula to improve readability and performance • Turn reusable formula logic into a custom function without scripting

Apply a calculation to multiple rows or cells with one formula
Name intermediate values inside a formula to improve readability and performance
Turn reusable formula logic into a custom function without scripting
Automatically generate a series of numbers in a dynamic range
Apply a structured workflow for advanced functions and dynamic calculations

3 h

Topic M08

Imports, connections and external sources

Retrieve a range from another authorized Google Sheets file • Import a table or list from a compatible web page • Analyze large data from supported sources such as BigQuery inside Sheets

Retrieve a range from another authorized Google Sheets file
Import a table or list from a compatible web page
Analyze large data from supported sources such as BigQuery inside Sheets
Automatically populate a sheet with Google Forms responses
Apply a structured workflow for imports, connections and external sources

3 h

Topic M09

Macros, Apps Script and automation

Record a sequence of repetitive actions so it can be replayed • Program custom automations and integrations around the spreadsheet • Automatically run a script based on time or an event

Record a sequence of repetitive actions so it can be replayed
Program custom automations and integrations around the spreadsheet
Automatically run a script based on time or an event
Expose Apps Script logic as a function usable in a cell
Apply a structured workflow for macros, apps script and automation

3 h

Assessment output

Actionable insight, not a sales pitch

The report provides an overall score, category breakdown and recommended modules. Use it to inform development discussions, document progress or complement candidate assessment.

View business use cases →

Privacy and recipients

The participant provides their email and that of the manager or authorized report recipient. The tool emails the report to those recipients according to its current process. Do not enter a third party without permission.

Review privacy information

Free assessment

Ready to assess your Google Sheets skills?

45 questions and a suggested development plan. No course enrollment.

Take the free test