Learning vocabulary for Google Sheets is learning how spreadsheet words change real actions. Start with cell, formula, range, filter, filter view, sort, viewer, commenter, editor, protected range and version history. If you can distinguish these terms, you can build a simple tracker, invite another person to inspect it, avoid accidentally changing someone else’s view and recover from common editing mistakes.
The fastest method is to make a small sheet with five columns, then practise one action at a time. Use SUM to total a quantity, IF to test a condition, a filter view to look at selected rows without changing colleagues’ views, and the Share settings to assign access. Google distinguishes a normal filter, which affects the shared sheet’s visible filter state, from a filter view, which can let different people use their own saved perspectives. Permission to edit a file is not the same as permission to look at it.
This is a practical vocabulary-learning guide for someone who needs Google Sheets for expenses, household planning, club activities, projects or small business. It is deliberately different from the existing Learning Vocabulary for Excel Formulas: that article concentrates on Excel calculations and error messages; here the central skill is collaboration, especially knowing which spreadsheet changes other people will see.
Quick answer: the eight Google Sheets words that control most beginner tasks
- Cell: an individual location, such as B2, where you enter a value or formula.
- Range: a group of cells, such as A2:D10, selected for a calculation, format or filter.
- Formula: an expression beginning with an equals sign that calculates a result.
- Sort: rearrange rows according to a rule, such as oldest-to-newest.
- Filter: temporarily show only rows meeting conditions; the underlying rows still exist.
- Filter view: save or use a particular filtered view without forcing every collaborator to see the same view.
- Sharing permission: set whether a person may view, comment or edit.
- Version history: inspect or restore a previous state when a collaborator has changed something incorrectly.
Definition lock: 20 terms in a collaborative spreadsheet
| Word | Meaning | Why a reader needs it |
|---|---|---|
| Spreadsheet | A file containing structured sheets, data and calculations. | The full file is not the same as one tab. |
| Sheet / tab | An individual worksheet inside a spreadsheet. | A file can contain many separately named tabs. |
| Cell | One row-and-column intersection, such as C4. | The most basic unit for data and formulas. |
| Row | A horizontal sequence of cells. | Often holds one record or transaction. |
| Column | A vertical sequence of cells. | Often holds one variable, such as Date or Amount. |
| Range | A defined set of cells. | Controls what a formula or sort operates on. |
| Header | A label describing a column or table. | Makes filters and reading more accurate. |
| Data validation | Rules that restrict or guide permitted values. | Reduces inconsistent entries. |
| Formula | An instruction for calculating an output. | Supports automatic totals or classifications. |
| Function | A named calculation such as SUM or COUNTIF. | Provides reusable operations. |
| Reference | A location used by a formula. | Can shift when copied unless anchored. |
| Sort | Change row order according to selected criteria. | The wrong selection can disconnect related fields. |
| Filter | Hide rows that do not match chosen conditions. | Hiding is not deleting. |
| Filter view | A named or temporary independent filtering perspective. | Lets multiple collaborators inspect data differently. |
| Viewer | A person permitted to view the file. | Does not automatically have edit access. |
| Commenter | A person permitted to comment without making ordinary content edits. | Useful for review and requests. |
| Editor | A person allowed to change file content. | Can alter data, formulae and many sharing-related workflows. |
| Protected range | Cells with editing restrictions or a warning. | Controls edits; it is not a secure vault for private data. |
| Version history | Record of earlier file states, where available. | Supports comparison and recovery. |
| Owner | The account controlling the file under Google Drive rules. | Some management and permission actions depend on ownership. |
Example sheet: build a five-column household purchase tracker
Open a new fictional Google Sheet and label columns A through E: Date, Item, Category, Amount, Status. Enter five example purchases with dates, descriptions, categories, amounts and a status such as “Paid” or “Pending”. Do not paste real private banking information into a shared practice file. The goal is to learn the words through a small table that another person can understand.
| Date | Item | Category | Amount (S$) | Status |
|---|---|---|---|---|
| 2026-11-01 | Notebook | Supplies | 12.00 | Paid |
| 2026-11-02 | Bus fare | Transport | 4.00 | Paid |
| 2026-11-03 | Printer paper | Supplies | 20.00 | Pending |
| 2026-11-04 | Coffee | Food | 6.00 | Paid |
| 2026-11-05 | Lunch | Food | 14.00 | Pending |
With this table, =SUM(D2:D6) produces 56 because 12 + 4 + 20 + 6 + 14 = 56. The cell letter D refers to the Amount column; the colon inside D2:D6 describes a continuous range. This is a better way to learn the word range than merely copying a definition. Try changing D3 from 4 to 5: the result should update to 57.
Formulas that solve everyday problems
| Formula | Meaning in plain English | What you must check |
|---|---|---|
=SUM(D2:D6) | Add amounts in a specified range. | Are all intended amount cells included? |
=AVERAGE(D2:D6) | Calculate the arithmetic mean of numeric values. | Are blanks and text being handled as intended? |
=COUNT(D2:D6) | Count numeric cells. | It is not the same as counting all nonblank cells. |
=COUNTA(B2:B6) | Count cells with content. | Does the column contain formulas returning empty text? |
=COUNTIF(E2:E6,"Paid") | Count matching status values. | Does every status use identical spelling? |
=SUMIF(C2:C6,"Food",D2:D6) | Total amounts for a matching category. | Are criteria and sum ranges aligned? |
=IF(D2>10,"Review","OK") | Choose one output if the test is true, another otherwise. | Is 10 the intended threshold? |
=IFERROR(A2/B2,"Check inputs") | Use a fallback when the calculation errors. | Do not hide serious data mistakes without investigating. |
The word criteria means the condition used to decide which values count. In =SUMIF(C2:C6,"Food",D2:D6), the category cells in C2:C6 are checked against Food; matching amounts in D2:D6 are added. If the category is written “food ” with a trailing space, it may no longer match as expected. This illustrates why consistent spelling and data validation matter more than memorising dozens of commands.
Formula vocabulary: relative versus absolute references
| Term | Example | What happens |
|---|---|---|
| Relative reference | D2 | When copied one row down, it generally becomes D3. |
| Absolute reference | $D$2 | The row and column stay fixed when the formula is copied. |
| Mixed reference | $D2 | Column D stays fixed while the row can change. |
| Mixed reference | D$2 | Row 2 stays fixed while the column can change. |
| Range reference | D2:D20 | The formula can use a series of adjacent cells. |
| Circular reference | A formula refers to itself, directly or through other formulas. | May produce an error or require explicit iterative settings. |
Imagine column E calculates tax from values in column D using a tax rate in cell H1. A formula such as =D2*$H$1 can be copied down. The dollar signs are anchors, not currency symbols in this position: they keep the rate cell fixed. This is one of the most useful vocabulary differences for anyone building reusable trackers.
Sort, filter and filter view: three different operations
| Operation | What changes | What does not necessarily change |
|---|---|---|
| Sort A to Z | The order of selected records. | It does not automatically remove any row. |
| Ordinary filter | Which rows are displayed when a filtering condition is active. | Hidden rows still remain in the sheet. |
| Filter view | The particular filtered perspective displayed to a person using that view. | Other editors can keep their own filter views. |
| Delete row | The actual underlying row and its data are removed. | It is not just hidden from sight. |
| Hide row | A row is visually hidden without deleting the data. | Formulas may still include its values. |
| Freeze header | Selected rows remain visible during scrolling. | It does not protect those rows from edits. |
| Protect range | The specified cells get an editing warning or restriction. | It does not necessarily hide their contents. |
Why you should select the entire table when sorting
Suppose the five sample purchase dates are in column A and the amounts are in column D. If you select and sort only column D, the amounts might move without their corresponding dates and item descriptions. That breaks the meaning of the table. The correct question is not simply “Can I sort amounts?” but “Does this sort preserve the relationship between each record’s fields?” When in doubt, select a proper range with headers, then verify entire rows move together.
How a filter differs from a filter view
Google’s official Sheets help explains that a normal filter’s settings are visible to people with access to the spreadsheet; editors may change that filter. A filter view is intended for a particular view, and different collaborators can use their own saved filter views. A viewer may be able to use a temporary filter view that cannot be permanently saved. The words filter and filter view sound nearly identical, yet choosing the wrong one can surprise other people working in the same document.
A five-minute filter exercise
- Start with five rows of purchase data and confirm all records are visible.
- Apply a normal filter to show only rows whose Status equals Paid.
- Read the total row count and notice that Pending records are not deleted.
- Remove that filter, create a filter view and show only the Supplies category.
- Return to the complete table and explain why a filtered view does not equal a permanent data change.
Sharing vocabulary: Viewer, Commenter and Editor
| Role | Typical permitted activity | What not to assume |
|---|---|---|
| Owner | Manages the file and its main sharing controls. | A collaborator with a link becomes the owner. |
| Viewer | Reads the shared file, subject to settings. | Can edit ordinary spreadsheet values. |
| Commenter | Reviews and comments where allowed. | Can directly rewrite cells merely by commenting. |
| Editor | Changes data, formulas and other permitted content. | Has unlimited rights independent of the file owner and organisation rules. |
| General access: Restricted | Limits sharing to selected permitted users and groups. | That a copied URL grants everyone access. |
| General access: Anyone with the link | Makes the file available more broadly under the selected role. | That the file remains private simply because it is unadvertised. |
The words share and publish are different. Sharing a Google Sheet with named colleagues does not require making it open to everyone. A publicly accessible sharing link can be forwarded; avoid putting private student information, household financial details, customer lists or confidential work into a file unless its access settings meet your obligations. Permission settings should be reviewed whenever the people working on a project change.
Protected ranges are not the same as privacy
A protected sheet or range helps prevent accidental or unauthorised editing by some collaborators, depending on its settings. It does not inherently hide the values or encrypt them against authorised viewers. A person who can view the sheet may still see sensitive content even if they cannot edit it. For genuinely private information, control who can access the file, consider separate files, and follow appropriate organisational safeguards.
Comments, suggestions and version history
| Word | Meaning | Practical situation |
|---|---|---|
| Comment | A note attached to a cell or range. | Ask a reviewer to check one unusual amount. |
| Assigned action | A task associated with a comment where supported. | Request a specific correction from a collaborator. |
| Resolved comment | A discussion marked as addressed. | The historical remark may remain accessible. |
| Version history | A record of previous saved states. | Find when a calculation was changed. |
| Restore version | Revert the file to a recorded earlier state. | Review whether later valid edits would also be affected. |
| Named version | A labelled historical checkpoint. | Mark the approved monthly budget. |
| Activity dashboard | Available information about file activity under some configurations. | Visibility depends on account and privacy settings. |
The difference between a correction and a rollback
If someone enters an incorrect amount into one cell, you can often correct that cell directly. Restoring an entire earlier version may also remove valid edits made later by other people. This is why change, undo, version and restore describe different operations. Decide whether the problem affects one value, one formula, one range or the entire spreadsheet before choosing the remedy.
Error messages: the vocabulary of a broken formula
| Error | Typical meaning | First check |
|---|---|---|
#DIV/0! | A formula attempted division by zero or a blank equivalent. | Inspect the divisor. |
#N/A | A requested match or value is unavailable. | Check lookup values and whether absence is expected. |
#REF! | A formula contains an invalid reference. | Check deleted rows, columns and broken references. |
#VALUE! | A calculation received an unsuitable type or input. | Look for text in a numeric calculation. |
#NAME? | A name or function reference is not recognised. | Check spelling and quotation marks. |
#ERROR! | Google Sheets could not parse or evaluate the entered expression. | Check formula structure and separators. |
#NUM! | A numeric operation is invalid for the supplied arguments. | Check limits and numeric inputs. |
#SPILL! | An error seen in certain spreadsheet environments when array output is blocked. | Check the actual application and array-output rules; do not assume all spreadsheets show identical errors. |
When a formula returns #N/A, do not automatically replace it with zero. “Not available” is different from “measured value of zero.” In a stock sheet, zero may mean nothing remains; missing data may mean nobody has checked. Similarly, using IFERROR to hide every error can conceal an important broken reference. Diagnose the cause before making the display prettier.
Four practical scenarios
Scenario 1: a class event registration sheet
Imagine a fictional club registration sheet with names, attendance and payment status. One organiser needs to edit registrations; two volunteers only need to review attendance. Giving everyone Editor permission may increase the risk of accidental changes. The useful words are owner, editor, viewer, restricted sharing and protected range. Avoid publishing personal details with an unrestricted link.
Scenario 2: a shopping comparison
A family lists household products, prices and shops in a spreadsheet. The relevant vocabulary is range, sort, filter, lowest price and formula. A filter can show one product category without removing the others. A formula can total selected costs. The family should remember that a shopping price is time-sensitive and the spreadsheet does not update a website’s stock automatically unless a specific mechanism supplies updated information.
Scenario 3: two managers analysing the same report
One manager needs to see the largest expenses, while another needs pending invoices only. A shared ordinary filter can confuse readers when it is changed. The term filter view offers an appropriate way for each person to inspect a different subset without imposing the same visible filtering on colleagues. The underlying data remains shared, so edits to a cell can still affect others.
Scenario 4: a wrong total after sorting
A sum looks wrong after someone sorted an amount column without moving the relevant names and dates. The question is not “Why doesn’t SUM work?” The data relationship may have been broken. Examine the current rows, version history and any range-specific sorting that occurred. Accurate vocabulary identifies whether the failure is in the formula, reference, sort range or source data.
A seven-day learning plan
| Day | Practice | Success test |
|---|---|---|
| 1 | Create a five-column sample tracker and label every field. | Can you identify row, column, cell and range? |
| 2 | Use SUM, COUNTIF and IF on the tracker. | Can you explain each formula without reading it aloud character by character? |
| 3 | Copy a formula containing a relative and then an absolute reference. | Can you predict which addresses change? |
| 4 | Sort a whole table and filter one category. | Are the correct records still associated? |
| 5 | Create a filter view and compare it with a normal filter. | Can you explain which view colleagues will see? |
| 6 | Share a safe practice file using Viewer, Commenter and Editor roles. | Can you predict which actions each role permits? |
| 7 | Make one reversible change and inspect version history. | Can you recover without deleting unrelated valid changes? |
Frequently asked questions
Is Google Sheets the same as Excel?
Both are spreadsheet tools with many overlapping concepts, but their collaboration interfaces, function support, storage models and some error behaviours differ. Learn the shared mathematical vocabulary while checking the actual application instructions.
Can I create a filter without deleting rows?
Yes. A filter changes what is displayed; it does not delete records. If rows disappear from sight, confirm whether a filter is active before assuming data was erased.
What is a filter view good for?
It lets someone apply a particular filtering perspective without necessarily changing the view other collaborators use. Google Sheets supports saved filter views under the conditions described in its current help.
Is protecting a range enough to secure a private spreadsheet?
No. Editing protection is different from access restriction, encryption or privacy. Limit file sharing to the people who should see the data.
Why does a copied formula change cell references?
Relative references adjust when formulas are copied. Use an appropriate absolute or mixed reference when an address must stay fixed.
Can I undo every mistake by restoring an old version?
Version history can help restore earlier states, but restoring a whole version may also undo later valid changes. Inspect the history and coordinate with collaborators before a broad rollback.
Original sources and further eduKateSG learning
- Google Docs Editors Help — Sort and Filter Your Data: normal filters, temporary and saved filter views.
- Google Docs Editors Help — Collaborate in Sheets: Viewer, Commenter, Editor, comments and protected ranges.
- Google Docs Editors Help — NA: why missing information differs from zero.
- Google Docs Editors Help — ERROR.TYPE: common spreadsheet error classifications.
- Learning Vocabulary for Excel Formulas: detailed reference and function practice.
- Everything You Need to Know About Google Drive: storage and sharing language.
- Learning Vocabulary for Monthly Budgeting: an applied project for learning totals.
Practical troubleshooting: 14 cases that teach the vocabulary
The most durable way to learn spreadsheet language is to recognise the difference between a word and its consequence. The following cases are everyday situations in which a vague description can lead to the wrong fix. Each starts with a problem someone could genuinely experience and identifies the exact question that should be asked before changing the shared file.
A shared team member says the totals disappeared
First ask whether the rows were deleted, filtered, hidden or moved. A filter can remove rows from the visible display without removing their data, while a deletion changes the underlying contents. Inspect the filter indicator, hidden-row controls and version history before restoring an entire earlier version. The vocabulary in your reply should be: “Which rows are filtered or hidden, and which values are genuinely missing?” That question avoids unnecessary changes to other people’s work.
A collaborator sorts one column and the descriptions no longer match
This is a record integrity problem. Each row should represent one coherent record: date, product, price and status. If one column is sorted separately, its values may be separated from their original records. Check recent edits and whether a correctly selected table range was used. Do not re-sort repeatedly in the hope of repairing the mismatch. When possible, recover the relevant range or previous version with collaborators aware of other recent changes.
A Viewer wants to analyse a filtered subset
The ability to view is not ordinary edit permission. Google Sheets allows a temporary filter view in certain circumstances even for people without editing rights. Such a view is not the same as a saved shared configuration. Tell the reader to use the available filter-view controls and not to request Editor access merely to hide irrelevant rows. If further analysis requires changing data or adding formulas, use a permitted copy or ask the owner for the appropriate access.
A person asks why a cell is ‘protected’ but readable
Protected describes an edit restriction. It does not inherently mean encrypted, hidden or confidential. If the sheet contains private account details, the owner should review the people and links who can access the file. A protected range can be appropriate for preventing accidental overwriting of formulas but should not be mistaken for a privacy barrier. The safer distinction is between write permissions and read permissions; they address separate risks.
Someone pastes an amount as text and the total seems too small
A spreadsheet may display a number-looking string that a calculation does not treat as an ordinary number. Look for currency symbols imported as characters, spaces, apostrophes, unexpected decimal separators or mixed formatting. Check the actual cell value and number format before changing the formula. A misleadingly tidy display can hide this input problem. The correct terms are data type, numeric value, text value and conversion.
An IF formula produces the wrong status for a boundary value
The comparison operator matters. The condition D2>10 differs from D2>=10. If an amount of exactly 10 should count as Review, the latter rule is appropriate; if only values greater than 10 qualify, the former is correct. The word threshold defines the boundary. State the business rule in ordinary language before editing formulas, and test values immediately below, exactly at and immediately above the threshold.
An IFERROR formula makes a bad report look perfect
IFERROR is useful when a fallback is genuinely appropriate, but it can also conceal a formula returning #REF! because data was deleted. The phrase “error handling” does not mean “erase all evidence of an error”. In a teaching or accounting sheet, distinguish an expected unavailable value from an unexpected calculation failure. A separate validation column may be safer than replacing every error with zero or an empty cell.
A category name is spelled inconsistently in different rows
A filter or SUMIF depends on criteria matching the intended entries. “Travel”, “travel” and “Travel ” can lead to confusing groupings depending on the exact operation and whitespace. Use a dropdown or data validation rule to provide consistent allowable choices, and clean old data carefully. Keep the original meanings intact during normalisation. Consistent labels make the sheet easier for humans and formulas to read.
Two colleagues need different filtered reports simultaneously
A single ordinary filter may affect the shared presentation. Instead, use a named filter view for each relevant question, such as “Unpaid invoices” and “Orders by customer”. These are views of the same underlying data, not independent duplicate databases. A correction to the underlying invoice amount will still affect the relevant totals in both views. Name views by their purpose so collaborators do not need to guess what the filters are intended to show.
A colleague believes making a copy prevents future confusion
A file copy can be useful for experimentation, but it also creates another version of the data that may become stale. The phrase source of truth means the agreed authoritative file for current work. Ask which file is primary, whether changes should be made there, and whether the experiment should be copied back after review. The vocabulary helps prevent two people updating divergent spreadsheets while both believe their copy is current.
A comment says ‘Please fix this’ without identifying a value
A useful comment names the cell, issue, proposed change and evidence. For example, “In row 14, the invoice amount differs from the supplier’s final receipt; please compare the two values.” This creates a specific review request rather than an ambiguous command. If the error is fixed, resolve the comment according to the team’s convention. Do not treat a resolved comment as evidence that the financial facts were independently verified.
The owner wants to share a sheet externally for one week
A sharing link, an individual permission and an expiration control are different settings. Google documents sharing-expiration options for eligible accounts and roles, but their availability depends on the environment. Before sharing, determine exactly who needs access, their necessary role, whether the file contains confidential details and how access will be reviewed at the end. Do not assume a copied link has an automatic one-week expiry just because an email mentions a deadline.
The report has a neatly formatted chart but totals disagree
A chart is a presentation of underlying data, not independent proof of correctness. Check the chart range, included rows, filters, formula results and source data. A chart can look polished while omitting a category or using an outdated range. Inspect the values that feed the chart before changing colour or layout. The right question is, “Which rows and columns are represented, and do they still match the stated purpose?”
Someone restores yesterday’s version and removes today’s work
A broad restoration can revert changes that other collaborators made after the chosen checkpoint. Compare the history first, identify exactly which mistake requires reversal, and coordinate before restoring the entire file. For a one-cell error, a targeted correction may be safer. The words revision, restore, revert, undo and snapshot should describe the scope of the action, not just the user’s desire to make a problem disappear.
Extra glossary: record integrity, access and data quality
| Useful word | Definition in this context | When to use it |
|---|---|---|
| Source of truth | The agreed authoritative document. | Two teams are updating different copies. |
| Duplicate | A repeated value or record requiring investigation. | A report counts the same order twice. |
| Unique identifier | A stable code distinguishing one record from another. | Names or dates can repeat. |
| Lookup key | A value used to find a matching record. | Joining customer names to order tables. |
| Blank | A cell with no entered value. | Not always equivalent to zero. |
| Null / missing | Information absent or unspecified in a data context. | A source did not supply a measurement. |
| Zero | A numeric value indicating none of a measured quantity. | An amount was counted and found to be 0. |
| Validation rule | A condition governing permitted entries. | Prevent an invalid date or status. |
| Dropdown | A selection control listing possible entries. | Standardise status labels. |
| Data type | A category such as number, text or date. | The sheet treats imported numbers as text. |
| Range expansion | Extending a calculation to additional rows. | New records are omitted from a total. |
| Audit trail | Information supporting a review of changes. | Work is shared across colleagues. |
| Reconciliation | Comparing records to identify differences. | Transactions disagree with statements. |
| Access review | Checking who can read or modify a file. | A project ends or a member leaves. |
| Version checkpoint | A saved state for review or rollback. | A monthly budget is approved. |
| Conditional formatting | Visual styling based on rules. | Highlight overdue items without sorting. |
| Pivot table | A summarised view that groups and aggregates records. | Count purchases by category. |
| Data source | The origin of the recorded information. | Numbers came from an export or manual entry. |
| Refresh | Updating a view or data connection where supported. | A report does not reflect new source data. |
| Permission boundary | Limit of actions allowed for a role. | A Viewer asks to change a formula. |
To make these words stick, do not memorise them as an alphabetised glossary. Start with a mistake: a missing number, an unexpected total or a colleague who can edit something they should only review. Then identify whether the problem concerns source data, formula logic, visibility, sorting, permissions or version history. Say the term aloud and explain which action it permits. That is a better test of understanding than repeating the definition without a real decision.
A practical collaboration rule is to establish a single authoritative spreadsheet, clear column definitions and a small number of accountable editors. Before someone introduces a new formula or reorganises rows, confirm the effect on existing charts, protected areas and linked calculations. Use a temporary working copy for experiments with substantial changes. These conventions are not complicated software features; they are agreed meanings for words such as ‘current’, ‘approved’, ‘editor’ and ‘final’.
Next useful step: Build a five-row sample sheet today. Create one total, one IF rule, one filter view and one Viewer link to an account you control. If you can explain who may see, edit and filter that data, you have learned the vocabulary that makes shared spreadsheets useful and safer.