Google Sheets Practice Test PDF 2026 June

Google Sheets Practice Test PDF – Free Download 2026

If you're preparing for a Google Sheets skills assessment and need a practice test PDF to study offline, you're in the right place. Google Sheets assessments are used by employers, staffing agencies, and professional certification programs to evaluate spreadsheet proficiency. This guide covers everything from basic formulas to advanced functions, pivot tables, and collaboration features. Download our free Google Sheets PDF below and use it alongside your preparation.

Google Sheets Fundamentals

Google Sheets is a cloud-based spreadsheet application that is part of Google Workspace (formerly G Suite). It runs entirely in a web browser, stores data automatically in Google Drive, and enables real-time collaboration between multiple users simultaneously. For skills assessments, you'll be tested on your ability to navigate the interface efficiently, structure data correctly, and apply the right tool for each task.

Core navigation skills include: understanding cell references (A1 notation), selecting ranges (A1:D10), freezing rows and columns for header visibility, hiding and unhiding rows/columns, using keyboard shortcuts (Ctrl+C/V/Z, Ctrl+Shift+V for paste special, Ctrl+Home/End for navigation, F2 to edit a cell, Ctrl+Enter to fill selected range), and managing multiple sheets within a workbook (renaming, reordering, color-coding tabs).

Data entry best practices tested on assessments include: keeping data types consistent within columns (don't mix text and numbers in a column used for calculations), using data validation to restrict entries to valid values, and understanding how Google Sheets auto-detects data types (entering 1/5 may be interpreted as January 5th — use an apostrophe prefix to force text).

Formulas and Functions

Formulas and functions are the core of any Google Sheets assessment. You need to know not just the syntax, but when to use each function and how to combine them.

SUM and SUMIF/SUMIFS: SUM adds a range (=SUM(A1:A10)). SUMIF adds values in a range based on a single condition (=SUMIF(range, criteria, sum_range)). SUMIFS handles multiple conditions (=SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2)). These are among the most frequently tested functions on assessments.

AVERAGE, MIN, MAX, COUNT, COUNTA, COUNTIF, COUNTIFS: COUNT counts cells with numbers; COUNTA counts non-empty cells regardless of type. COUNTIF counts cells meeting a single condition; COUNTIFS handles multiple conditions. Know the difference between COUNT and COUNTA — a common trick question on assessments.

IF and nested IF: The IF function returns one value if a condition is true and another if false: =IF(logical_test, value_if_true, value_if_false). Nested IFs chain multiple conditions: =IF(A1>90,"A",IF(A1>80,"B",IF(A1>70,"C","F"))). For complex multi-condition branching, IFS is cleaner: =IFS(A1>90,"A",A1>80,"B",A1>70,"C",TRUE,"F").

VLOOKUP: Vertical lookup finds a value in the first column of a range and returns a value from a specified column: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]). The fourth argument (range_lookup) is critical — FALSE for exact match, TRUE (or omitted) for approximate match. VLOOKUP only searches left-to-right and can only return values to the right of the lookup column. This is its key limitation.

INDEX/MATCH: INDEX returns the value at a given row/column position in a range; MATCH returns the position of a value within a range. Combined, they create a more flexible lookup: =INDEX(return_range, MATCH(lookup_value, lookup_range, 0)). Unlike VLOOKUP, INDEX/MATCH can look left, works with unsorted data when using exact match, and doesn't break when columns are inserted. Most advanced users prefer INDEX/MATCH over VLOOKUP for all but the simplest lookups.

XLOOKUP (if available): XLOOKUP is Google Sheets' modern replacement for VLOOKUP — =XLOOKUP(search_key, lookup_range, result_range, [if_not_found], [match_mode], [search_mode]). It searches both vertically and horizontally, returns full rows or columns, and handles not-found values natively. Check whether your assessment version of Sheets supports XLOOKUP.

TEXT functions: CONCATENATE or the ampersand operator (&) joins text strings. LEFT, RIGHT, and MID extract substrings. LEN returns string length. TRIM removes extra spaces. UPPER, LOWER, PROPER change case. FIND and SEARCH locate substrings (SEARCH is case-insensitive). These are regularly tested in data cleaning scenarios.

Date functions: TODAY() returns the current date. NOW() returns current date and time. DATEDIF calculates intervals between dates. DAYS, EDATE, EOMONTH (end of month) are all tested. Date serial number arithmetic (subtracting two dates gives the number of days between them) is a common question type.

Data Validation

Data validation restricts what can be entered in a cell or range. You access it via Data → Data Validation. Validation types include: list of items (creates a dropdown), number range, text length, custom formula, and date range. Data validation is used to prevent data entry errors and enforce consistent categorization — for example, restricting a "Status" column to only accept "Open", "In Progress", or "Closed".

On skills assessments, data validation questions often ask you to identify the correct validation type for a scenario or to troubleshoot why a validation rule isn't working as expected.

Conditional Formatting

Conditional formatting changes a cell's appearance (fill color, text color, bold) based on rules you define. Rules can be based on cell values, text content, dates, custom formulas, or comparisons to other cells. You can apply multiple rules to the same range, with priority determined by rule order — rules higher in the list take precedence.

Common assessment scenarios: highlight all cells in a column with values above a threshold in red, apply a green-to-red color scale across a range based on relative values (gradient color scale), or use a custom formula rule to highlight an entire row when a specific cell in that row meets a condition (e.g., =$D2="Complete" to highlight rows where column D says "Complete").

Pivot Tables

Pivot tables summarize large datasets by grouping, aggregating, and cross-referencing data dynamically. In Google Sheets, insert a pivot table via Insert → Pivot Table. You drag fields to Rows, Columns, Values, and Filters sections. Values fields can be aggregated by SUM, COUNT, AVERAGE, MAX, MIN, or other functions.

Skills assessments test your ability to: create a pivot table from a flat data range, add fields to the correct sections, change the aggregation function for a value field, filter the pivot table by a specific field value, and interpret pivot table output. Understanding how to refresh a pivot table after source data changes (in Google Sheets, pivot tables update automatically) is also tested.

Charts and Graphs

Charts are inserted via Insert → Chart. Google Sheets automatically suggests a chart type based on your selected data. Tested skills include: selecting the correct chart type for the data (bar/column charts for comparisons, line charts for trends over time, pie charts for proportions, scatter plots for correlations), modifying chart titles and axis labels, changing chart type after creation, and moving a chart to a different location on the sheet.

Google Sheets vs Excel: Key Differences

Many assessments specifically test your awareness of Google Sheets limitations and differences from Excel. Key differences: Sheets stores data in the cloud (Excel has local files by default). Sheets enables real-time multi-user collaboration natively; Excel requires OneDrive or SharePoint for similar functionality. Sheets has a 10 million cell limit per spreadsheet vs Excel's ~17 billion. Sheets uses Google's formula engine — most Excel formulas work, but some advanced Excel features (Power Query, named tables with structured references, some macros) behave differently. Sheets uses Google Apps Script (JavaScript-based) for automation; Excel uses VBA.

Collaboration Features

Google Sheets collaboration features are a major differentiator from Excel and are heavily tested on Google Workspace assessments. Key features: sharing with specific individuals (Viewer, Commenter, or Editor access), sharing via link (anyone with link can view/comment/edit), suggesting edits (analogous to Word's "Track Changes"), leaving comments (Ctrl+Alt+M or right-click → Comment), tagging users in comments with @email, resolving and deleting comments, and version history (File → Version History → See Version History) which lets you view and restore any previous state of the document.

IMPORTRANGE and QUERY Functions

IMPORTRANGE pulls data from another Google Sheets spreadsheet: =IMPORTRANGE("spreadsheet_url", "Sheet1!A1:D100"). The first time you use it, you must grant access permission. This function enables cross-sheet data aggregation without manual copying.

QUERY is one of Google Sheets' most powerful functions — it applies SQL-like queries to a data range: =QUERY(data, "SELECT A, B, C WHERE D='Active' ORDER BY B DESC LIMIT 10"). The query string uses a subset of SQL (BigQuery dialect). QUERY is used for filtering, sorting, aggregating, and pivoting data using a single formula. It's a differentiating skill on advanced assessments.

Google Apps Script Basics

Google Apps Script (GAS) is a JavaScript-based platform for automating Google Workspace. Accessible via Extensions → Apps Script. While most skills assessments don't test deep scripting knowledge, intermediate-to-advanced assessments may ask about: what Apps Script is and when to use it vs built-in functions, how to create a custom function (a script function that can be called in a cell like =MYFUNC()), how triggers work (time-based, on-open, on-edit), and basic debugging in the Apps Script editor.