What does the term “formula” refer to in a spreadsheet?

What does the term “formula” refer to in a spreadsheet?

  1. A graph representation
  2. A predefined layout
  3. A predefined calculation ✓
  4. A text formatting rule

Explanation

Formulas are equations that perform calculations in spreadsheet cells. They start with an equals sign like =A1+B1 to add two numbers. Formulas automatically update when you change the data.

Graphs visualize data but aren’t formulas. Layouts arrange cells visually. Text formatting changes appearance, not calculations.

Formulas make spreadsheets powerful by automating math. You write the formula once and it calculates results instantly.