TOPIC 10

TOPIC 10

1. CELLS

   • A cell reference always starts with a letter and ends with a number
   • A range of cells is a set of cells in a row or column
   • Data entered into cells can be different data types
   • Each cell can contain... labels, data , formulas and functions

2. Formulas

   • Must start with an =
   • Formulas perform calculations on cell contents
   • Formulas appear in the formula bar
   • The result of the formula is automatically recalculated every time the data on a spreadsheet changes

3. Functions