USING MICROSOFT EXCEL
USING DATA VALIDATION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following are Data Validation types?
|
|
Length
|
|
|
Range
|
|
|
Type
|
|
|
All of the above
|
Explanation:
Detailed explanation-1: -The following are the common Data Validation Types: Code Check. Range Check. Format Check. Consistency 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: -As shown on the figure above, there are four nested levels of vis design, including domain situation, task and data abstraction, visual encoding and interaction idiom, and algorithm. Each level have different threats to validity, and validation approaches should be chosen accordingly.
There is 1 question to complete.