# spreadsheet concepts

the vocabulary behind formulas, references and recalculation.

- [Absolute and relative references](https://deepcalc.com/docs/concepts/absolute-and-relative-references.md): Why a reference changes when you copy a formula, and how $ stops it.
- [A1 notation](https://deepcalc.com/docs/concepts/a1-notation.md): How cells, ranges and worksheets are addressed in a formula.
- [Structural edits](https://deepcalc.com/docs/concepts/structural-edits.md): What happens to formulas when rows or columns are inserted, deleted or moved.
- [Array formulas](https://deepcalc.com/docs/concepts/array-formulas.md): Formulas that operate on many values at once and return many results.
- [Spill range](https://deepcalc.com/docs/concepts/spill-range.md): The block of cells a multi-value formula writes its results into.
- [Circular references](https://deepcalc.com/docs/concepts/circular-references.md): A formula that depends, directly or indirectly, on its own result.
- [Volatile functions](https://deepcalc.com/docs/concepts/volatile-functions.md): Functions that recalculate on every change, whatever their inputs did.
- [Recalculation](https://deepcalc.com/docs/concepts/recalculation.md): How a change to one cell propagates through everything that depends on it.

source: https://deepcalc.com/docs/concepts