Excel Terms Explained: Cell, Range, Reference and More
Plain-English explanations of Excel terms beginners trip over: cell, range, reference, formula vs function, argument, fill handle, absolute reference and more.
By Ayoub Farid · · 3 min read
Excel tutorials assume you know the words. If "argument", "range" or "absolute reference" sound vague, every explanation after that gets harder. Here are the terms that matter, explained with one example each.
The grid
Cell
One box in the grid. It can hold a number, text, a date or a formula.
Column and row
Columns go down and are named with letters (A, B, C… then AA, AB). Rows go across and are numbered (1, 2, 3).
Cell address (cell reference)
The column letter plus the row number. B2 is column B, row 2. When you write =B2 in a formula, you're referencing that cell.
Range
A rectangle of cells, written first cell, colon, last cell. B2:B13 is twelve cells in column B. A1:C3 is a 3×3 block.
Worksheet and workbook
A worksheet is one tab (one grid). A workbook is the whole file, which can hold many worksheets.
Formulas
Formula
Anything you type that starts with =. It calculates a result. =B2*C2 is a formula.
Function
A named, built-in calculation you use inside a formula. In =SUM(B2:B13), SUM is the function.
Argument
The inputs a function needs, inside the brackets, separated by commas. In =IF(B2>100,"High","Low") there are three arguments: the test, the value if true, the value if false.
Operator
A symbol that does maths or compares: + - * / and ^ (power), & (join text), and comparisons = < > <= >= <>.
Formula bar
The long box above the grid that shows the formula behind the selected cell. The cell shows the result; the formula bar shows how it's calculated.
Copying formulas
Fill handle
The small square at the bottom-right corner of a selected cell. Drag it down to copy a formula to the rows below. See fill down.
Relative reference
A normal reference like B2. When you copy the formula down one row, it becomes B3. Excel adjusts it relative to the new position.
Absolute reference
A reference with dollar signs, like $B$14. It stays exactly the same when copied. Use it for totals, rates and anything every row should point at. Full guide: absolute references.
Mixed reference
Only one part locked: $B2 (column locked) or B$2 (row locked). Useful for grids. See mixed references.
Results and errors
Value
What a cell actually holds or shows: 4,200, "Latte", 15/03/2026.
Error value
What Excel shows when a formula can't work: #DIV/0!, #N/A, #VALUE!, #REF!, #NAME?. Each one has a specific cause, explained in Excel formula errors.
Spill
In Excel 365 and Google Sheets, some formulas return several values that "spill" into neighbouring cells, like UNIQUE or FILTER.
Learn the words by using them
The fastest way to make these terms stick is to use them in real formulas. In Cellio, the first lessons are built around exactly these ideas: you tap cells to add references, tap another to make a range, and use the $ key to lock a cell, so the vocabulary turns into muscle memory.
Frequently asked questions
What is the difference between a formula and a function?
A formula is the whole calculation starting with =. A function is a named tool like SUM or IF used inside it.
What does a colon mean in Excel?
It creates a range. B2:B13 means every cell from B2 to B13.
What does the $ sign mean in Excel?
It locks part of a reference so it doesn't change when the formula is copied.
What is a cell reference?
The address of a cell, like B2, used in a formula so the result updates when that cell changes.