Unit 20 CIE ICT IGCSE Spreadsheet key terms

eg $A$6

a reference to a cell used in a formula where, when the formula is copied to a new address, the cell address does not change.

• Absolute reference

• wrap text

• label

• nested formula / functions

A way of holding data in a file so that it can be transferred into databases or spreadsheets.

• CSV comma separated variables.
• Absolute reference
• wrap text
• label

raw facts and figures, e.g. readings from sensors, survey facts, etc.

• Data
• CSV comma separated variables.
• Absolute reference
• wrap text

validation check to ensure the data being entered is the same type as the data type specified for the field.

• Data type check
• Data
• CSV comma separated variables.
• Absolute reference

entering the details into an ICT system twice; only if the two sets of data are identical will they be accepted for processing. It is a method of verification. This method is often used when you set up a new password.

• Double entry of data
• Data type check
• Data
• CSV comma separated variables.

is data on the borderline of what the system will accept. For example, if a range check specifies that a number from 16 to 21 inclusive is entered, the extreme data would be 16 and 21.

• Extreme data
• Double entry of data
• Data type check
• Data

validation check to make sure that the data being entered has the correct number of characters in it.

• Length check
• Extreme data
• Double entry of data
• Data type check

data that is acceptable for processing and will pass the validation checks.

• Normal data
• Length check
• Extreme data
• Double entry of data

validation checks used to ensure that data has been entered into a field.

• Presence checks
• Normal data
• Length check
• Extreme data

when a cell is used in a formula and the formula is copied to a new address, the cell address changes to take account of the formula’s new position.

• Relative reference
• Presence checks
• Normal data
• Length check