Grade 7 - Ch6 Data

A set of cells in a horizontal line

• A column

• A row

• A cell

• A table

A set of cells in a vertical line

• A column

• A row

• A cell

• A table

A single square in a spreadsheet that stores data

• A column

• A row

• A cell

• A table

A 2 dimensional collection of data stored in rows and columns

• A column

• A row

• A cell

• A table

A field is ....

• a set of data stored in a row which contains a information about a single item or person

• a set of data stored in a column which contains a single category like size or name

A record is ....

• a set of data stored in a row which contains a information about a single item or person

• a set of data stored in a column which contains a single category like size or name

An atomic data is ...

• an equation you enter manually

• a built in sub programme

• data which is can not be split into smaller parts

• a way of minimising bad data being entered into our spreadsheet or database

A function is ...

• an equation you enter manually

• a built in sub programme

• data which is can not be split into smaller parts

• a way of minimising bad data being entered into our spreadsheet or database

A formula is ...

• an equation you enter manually

• a built in sub programme

• data which is can not be split into smaller parts

• a way of minimising bad data being entered into our spreadsheet or database

Validation rules are ...

• an equation you enter manually

• a built in sub programme

• data which is can not be split into smaller parts

• a way of minimising bad data being entered into our spreadsheet or database