DATABASE FUNDAMENTALS
USING DATA VALIDATION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
How many Data Validation Types are there?
|
|
1
|
|
|
2
|
|
|
3
|
|
|
4
|
Explanation:
Detailed explanation-1: -Format Check. Consistency Check. Uniqueness Check.
Detailed explanation-2: -Time-The user should enter a time. Text Length-It validates input based on the length of the data. Custom-It validates the user input using a custom formula.
Detailed explanation-3: -There are three types of validation rules in Access: 1. Field Validation Rule You can use a field validation rule to specify a criterion that all valid field values must meet.
There is 1 question to complete.