happy

 


Spreadsheets

A spreadsheet is a program used for handling numbers and calculations and drawing charts.

It shows the information in rows and columns.

Rows run across the grid and are labelled with numbers.

Columns run up and down the grid and are labelled with letters.

 

image

 

A cell is a box on the spreadsheet grid named from the row and column which it occupies.

A cell can hold 3 types of data:

values eg 47, 132, 0.98

text eg Total, Monday

formula eg = B1 + C1

The row number and column letter identifies the cell by giving it a cell address.