Spreadsheet software allows data and information to be displayed and managed in a table format. Spreadsheets are mathematical tables which show data in cells that are organized in rows and columns. A spreadsheet allows calculations to be carried out on cells or groups of cells, both within individual spreadsheets and across linked spreadsheets.
A column is a vertical line of cells labelled with a letter.
A row is a horizontal line of cells labelled with a number
A cell is an intersection of a column and a row, it is labelled with a letter and a number, it can hold three types of data: text, numbers and formulae.
Formulae are entries that have an equation which calculates the value to display. We can calculate totals, percentages, average, etc. When you change the value of one cell, the values of other cells are automatically recalculated.
© Střední průmyslová škola elektrotechniky a informatiky, Ostrava, příspěvková organizace