FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

USING DATA VALIDATION IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
How many Data Validation Types are there?
A
1
B
2
C
3
D
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.