USING MICROSOFT EXCEL
USING DATA VALIDATION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
A user is required to enter “between 5 to 8 characters in a cell". Which data validation check is used?
|
|
Length
|
|
|
Range
|
|
|
Type
|
|
|
All of the above
|
Explanation:
Detailed explanation-1: -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-2: -Select the cell(s) you want to create a rule for. Select Data >Data Validation. On the Settings tab, under Allow, select an option: Whole Number-to restrict the cell to accept only whole numbers.
There is 1 question to complete.