Spreadsheet functions for manipulating and validating data

Spreadsheet functions for manipulating and validating data

1. Range checking

   • Ensure data in within range
   • Example: 0-100, only those numbers can be entered
     • Error messages if out of range

2. Existence checking

   • Checks to see if specifed value is present

3. Data type checking

   • To ensure data is of particular type
   • Examle, phone number should be numbers not letters

4. Restricted data entry

   • Only allows certain data can be used
     • Can be selected by a drop box
   • Prevents user from entering incorrect data

5. Validation alerts

   • Pop ups that alert you if you have entered wrong data
   • Prevent you from entering incorrect data
   • IF statements can also be used