Concepts
The vocabulary behind formulas, references and recalculation: what each term means, and what it implies when an agent is editing the sheet.
Absolute and relative referencesWhy a reference changes when you copy a formula, and how $ stops it. A1 notationHow cells, ranges and worksheets are addressed in a formula. Structural editsWhat happens to formulas when rows or columns are inserted, deleted or moved. Array formulasFormulas that operate on many values at once and return many results. Spill rangeThe block of cells a multi-value formula writes its results into. Circular referencesA formula that depends, directly or indirectly, on its own result. Volatile functionsFunctions that recalculate on every change, whatever their inputs did. RecalculationHow a change to one cell propagates through everything that depends on it.