ICT

all about spreadsheets on excel.

HideShow resource information
  • Created by: Halimah
  • Created on: 16-05-11 16:35

Spreadsheets

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

1 of 2

Vocab

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%

2 of 2

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all resources »