Spreadsheets

Spreadsheets

1. Cells

   • A cell reference always starts with a letter and ends with a number e.g. A5 or H28
   • A range of cells is a set of cells in a row or column
   • Data entered into cells can be different data types e.g. text, number, currency, date, percentage etc.
   • Can Include:
     • Labels – any text in a cell describing the data in a row or column(titles, headings that identify data)
     •  Data – any values (text or numbers) that are entered for the use of calculation
     •  Formulas and functions – mathematical calculations carried out automatically

2. Formulas

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

3. Functions

   • Must also start with an =
   • Functions are part of spreadsheet software. They are specialised calculations built in to the spreadsheet software.
   • Function name describes what a function can do SUM, COUNT, AVERAGE, MIN, MAX, IF  =SUM(D2:F7)

4. Formatting

   • The content of a cell can be formatted: Font style, size, colour, border style, alignment, cell colour, Multiple cells can be merged in to one cell
   • Cells are often formatted to reflect the data that is held in them. Data types include: □ Currency, number, real, integer (whole number), date, text