Excel terms
- Absolute reference — A cell reference locked with $ signs so it doesn't change when copied.
- Argument — A value passed into a function inside its parentheses.
- Array formula — A formula that operates on a range of values rather than a single cell.
- Circular reference — A formula that refers, directly or indirectly, to its own cell.
- Conditional formatting — Rules that change a cell's appearance based on its value.
- Defined name (Named range) — A human-readable name assigned to a cell, range, constant, or formula.
- Dynamic array — A formula that returns multiple values which spill into adjacent cells.
- Formula bar — The bar above the worksheet that shows and edits the active cell's content.
- Function — A built-in formula that performs a specific calculation.
- Mixed reference — A reference where either the row or the column is locked, but not both.
- PivotTable — An interactive tool that summarises and groups data from a table or range.
- Power Query — Excel's data import and transformation engine (Get & Transform).
- Range — A group of two or more cells, written as A1:B10.
- Relative reference — A cell reference (like A1) that adjusts when copied to other cells.
- Spill range — The cells filled by a dynamic array formula's results.
- Structured reference — A reference that uses table and column names instead of cell addresses.
- Volatile function — A function that recalculates on every worksheet change.
- Workbook — An Excel file. Contains one or more worksheets.
- Worksheet — A single sheet (tab) inside a workbook.
- #DIV/0! error — A formula tried to divide by zero or by an empty cell.
- #N/A error — A lookup function couldn't find the value you asked for.
- #REF! error — A formula refers to a cell that no longer exists.
- #VALUE! error — A formula received the wrong type of argument.