Data Entry Validation
Data validation:
An acceptable range of recorded air temperature values from a temperature sensor could be between
Types of Data Entry Validation
Validation types
Check Digit
Data Validation Example
Weather and events in Saudi Arabia
Data validation steps
LookUp and Presence Validation Check in Excel
To start Data Validation in Excel:
To apply LookUp and Presence check in Excel:
To set an invalid Input Message:
To set an Error message:
Error message of lookup validation
Validated data table
Length Validation Check in Excel
To start the validation process:
To apply Length validation check in Excel:
Figure 2.30: Set an invalid input message
Figure 2.31: Set an error message
Input and error message of length validation
Figure 2.33: Validated data table
Range Validation Check in Excel
To start the validation process:
To apply Range validation check in Excel:
Figure 2.36: Set an invalid input message
Figure 2.37: Set an error message
Figure 2.38: Input and error message of range validation
Figure 2.39: Validated data table
Format Validation Check in Excel
To start the validation process:
To apply Format validation check in Excel:
To set an invalid Input Message:
Figure 2.43: Set an error message
Figure 2.44: Input and error message of range validation
Figure 2.45: Validated data table
Type Validation Check in Excel
To start the validation process:
To apply Type validation check in Excel:
Figure 2.48: Set an invalid input message
Figure 2.49: Set an error message
Figure 2.50: Input and error message of type validation
Figure 2.51: Validated data table
Read the sentences and tick True or False: Data validation refers to the procedure that automatically deletes any raw data that does not meet certain criteria.
Briefly explain what data entry validation is.
Explain the steps that a user follows in Microsoft Excel in order to perform data validation.
Create an address book table of your friends' information which will include the fields: Name, Telephone, Home address, Email address, Birthday, Hobby. Next, write down what type of data vali
Compare the following: (a) Length check vs Range check, (b) Format check vs Type check. Give examples of the use of each validation type.
