ICT

A spreadsheet appears as a grid, each row has its own number and each column has its own letter. This labelling of rows and columns is used to give each cell a cell reference e.g C5 means column C row 5.

Teachers

Accoutants

Bankers

Shopkeepers

Buisness men

All use Spreadsheets

Active cell - It is the cell with the black border. Data can only be entered in this cell.

Cell Reference - labelloing of rows and columns e.g D6 column D row 5

Value - number which can be entered in the cell

Formula - Equation used to clculate a value e.g =d5*c5

Calculation        Symbol             Example

Subtract               -                    =A1-A2

Multiply              *                      =A1*A2

Divide                /                      =A1/A2

Percentage        %                   =A1%17.5%