Validation

Validation makes sure that data is

• Correct

• Suitable

• Nonsense

• Numerical

One of these is a type of validation

• Hardware

• Emotional

• List

• Spreadsheet

Range validation checks data is

• correct

• within limits

• a whole number

• not a decimal

Verification is checking the data is

• Secure

• Correct

• Suitable

• From a list

Type validation can check your data is the right

• value

• type

• size

• picture

In Excel you can get validation on which toolbar

• Data

• Edit

• Insert

• Formulas

Which of these will calculate a total

• =sum(F2:F20)

• =F2:F10

• =sum(F2,F10)

• =SUMF2:F10

Which will subtract two values

• F4-G4

• =F4+G4

• =F4-G4

• F4:G4

A text length validation of up to 10 characters will not accept:

• Timothy

• Timothy James

• Jamie

• Paula

Why is Validation useful

• It makes sure all the data is correct

• It keeps data secure

• It prevents errors typing data in

• It keeps the data up to date