Excel Terms Glossary: 40 Words Explained Simply

This Excel terms glossary explains the 40 words you meet most often, from cell and range to argument, spill and PivotTable. Each definition is one or two plain sentences with a small example. It is written for beginners, people returning to Excel, and anyone reading job ads or test instructions full of words they half know.

Workbook and grid terms#

These words describe the file and the grid you work in.

1. Workbook: the Excel file itself, such as Budget.xlsx. One workbook can hold many worksheets.
2. Worksheet (sheet): one page of the grid, shown as a tab at the bottom of the window, such as Sheet1.
3. Row: a horizontal line of cells, numbered 1, 2, 3 down the left side.
4. Column: a vertical line of cells, lettered A, B, C across the top. After Z come AA, AB and so on.
5. Cell: one box in the grid, where a row and a column meet. It holds a number, text, a date or a formula.
6. Cell address: the name of a cell, column letter first and row number second, such as B3.
7. Range: a block of cells next to each other, written with a colon: A1:A10 is ten cells in column A, and A1:C3 is a 3×3 block.
8. Active cell: the selected cell, with a thick border. What you type goes here.
9. Name Box: the box to the left of the formula bar that shows the active cell's address. Type an address there and press Enter to jump to it.
10. Formula bar: the long bar above the grid that shows what is really in the active cell, such as the formula behind a result.
11. Ribbon: the band of tabs and buttons at the top (Home, Insert, Formulas, Data and so on).
12. Fill handle: the small square at the bottom-right corner of a selection. Drag it to copy a formula or continue a series like 1, 2, 3.

The lesson on cells, rows and columns lets you practise naming and selecting cells and ranges. If text spills over its cell, widen the column; see how to autofit column width.

Formula and function terms#

These words describe calculations. They appear in almost every Excel test.

13. Formula: anything you type that starts with =, such as =B2*C2. Excel shows the result in the cell and the formula in the formula bar.
14. Function: a named, built-in calculation such as SUM, AVERAGE or IF. You use functions inside formulas: =SUM(B2:B6).
15. Argument: a value a function needs, written inside its brackets and separated by commas. In =ROUND(B2,2), the arguments are B2 and 2.
16. Syntax: the rule for how a function must be written, such as =IF(logical_test, value_if_true, value_if_false). Arguments in square brackets are optional.
17. Operator: a symbol that does something: + - * / for maths, ^ for powers, & to join text, and = < > <= >= <> to compare.
18. Order of operations (precedence): the order Excel calculates in. Brackets come first, then powers, then multiply and divide, then add and subtract. =10+2*3 returns 16, not 36.
19. Criteria: the condition a function such as COUNTIF or SUMIF checks, such as "North" or ">=100".
20. Nested function: a function inside another function, such as =ROUND(AVERAGE(B2:B6),1).
21. Error value: a code Excel shows when a formula can't work: #DIV/0! (division by zero), #N/A (value not found), #NAME? (a typo in a name), #VALUE! (wrong type of data) and #REF! (a deleted cell).
22. Circular reference: a formula that refers to its own cell, directly or through other cells. Excel warns you, because it can't finish the calculation.

To write your first formulas in a real sheet, try the first formulas lesson.

Cell reference terms#

A reference tells a formula which cell to use. How it behaves when copied is one of the most tested ideas in Excel.

23. Cell reference: a cell address used inside a formula, such as B2 in =B2*2. If B2 changes, the result updates.
24. Relative reference: a normal reference like B2. When you copy the formula down one row, it becomes B3.
25. Absolute reference: a reference locked with dollar signs, like $B$2. It stays the same wherever you copy it. Press F4 on Windows (or ⌘T on a Mac) to add the $ signs.
26. Mixed reference: only the column or only the row is locked, like $B2 or B$2.
27. Named range (defined name): a name you give to a cell or range, such as TaxRate, so formulas read =B2*TaxRate.

The guide to Excel cell references explained has worked examples of all four types.

Data and table terms#

These words matter once you work with lists, such as sales records or staff tables.

28. Excel table: a range turned into a table with Insert > Table (or Ctrl+T on Windows). Tables grow automatically and copy formulas down new rows.
29. Header row: the first row of a list or table, with a label for each column, such as Name, Date and Amount.
30. Sort: put rows in order, such as A to Z or largest to smallest.
31. Filter: hide the rows you don't need for now, using the drop-down arrows in the header row. Hidden rows are still there.
32. Data validation: a rule that limits what can be typed into a cell, such as whole numbers from 1 to 10.
33. Drop-down list: a type of data validation that lets people pick a value from a list instead of typing.
34. PivotTable: a tool that summarises a long list into a small table of totals, counts or averages, by dragging fields. No formulas needed.
35. Chart: a picture of your numbers, such as a column, line or pie chart.
36. Spill (dynamic array): in Excel 2021 and Microsoft 365, one formula can return many results that "spill" into the cells below or beside it. If those cells aren't empty, you see #SPILL!.

Formatting and view terms#

These words change how data looks or how you see the sheet, not the values themselves.

37. Number format: how a value is displayed, such as currency, percentage or a date. The value underneath stays the same: 0.25 shown as 25% is still 0.25.
38. Conditional formatting: formatting that changes with the value, such as turning cells red when they are below target.
39. Freeze panes: keeps the top rows or left columns in view while you scroll (View > Freeze Panes).
40. Flash Fill: Excel spots a pattern you type, such as first names taken from full names, and fills in the rest of the column (Data > Flash Fill, or Ctrl+E on Windows).

Which Excel terms should you learn first?#

Learn the grid words (1 to 12) first, then formula and reference words (13 to 27). They are what every formula and every test instruction uses. Data and formatting words make more sense once you have a real list in front of you.

Reading definitions only goes so far: you remember a term for good once you've used it. That's why hands-on practice beats watching; see video courses vs hands-on Excel practice. For a realistic timeline, read how long it takes to learn Excel, and for practice tasks, try these Excel exercises for beginners.

Practise it#

Use three of these words right now in the exercise on this page: a formula with the SUM function and a range as its argument. Then practise cells, rows and columns in a live spreadsheet and write your first formulas: you type into a real grid and each step is checked instantly. Not sure where to start? The Excel level test shows which terms and skills to focus on.