USING MICROSOFT EXCEL
USING DATA VALIDATION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Length
|
|
|
Range
|
|
|
Type
|
|
|
All of the above
|
Detailed explanation-1: -The correct answer is Data validation. Data validation allows you to enter only that data in a cell that satisfies the criteria.
Detailed explanation-2: -Select Data >Data Validation. On the Settings tab, under Allow, select an option: Whole Number-to restrict the cell to accept only whole numbers.
Detailed explanation-3: -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-4: -Text length-validates input based on number of characters or digits. For example, you could require code that contains 5 digits. Custom-validates user input using a custom formula. In other words, you can write your own formula to validate input.