Data systematisation in Excel

19.09.2016 08:26

Data systematisation un Excel is used to difference the data types and organise information more effectively

Name text type 

Telephone numeric 

ID between 

Activity 

1. What data validation must you use to input a plate number in Colombia?

2.What data validation do you need to input an address?

3. What validation do you need for telephone number in Colombia?

4. What validation for birthdays?

5. What validation do you need for clock times?

Hour

- integers        -hour

-decimals        - lenght of text

-list_____        - 

-date please enter the time, the time is incorrect please try again 

  1. We use length of text validation   Min 25 max 100.
  • please enter your plate , sorry your plate is incorrect try again 

      2. We use length of text for validation adrede Min 25 max 100

  • Please enter your password, your password is incorrect try again 

       3.We use a intergers for validation telephone number min 0 max 10 

  • please enter your phone number, is incorrect try again 

       4.We use date for birthday validation min 01/01/1900 max 09/19/2016

  • please enter your birthday date, sorry your number is incorrect try again 

        5. We use hour for clock time validation min 0:00 max 23:59

  • please enter the time, the time is incorrect please try again