USING MICROSOFT EXCEL
USING DATA VALIDATION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
if I entered an unreasonable grade then excel knows it through sorting
|
|
true
|
|
|
false
|
|
|
Either A or B
|
|
|
None 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: -Data validation is used to restrict the type of data or the values that users enter into a cell. One of the most common data validation uses is to create a drop-down list. It allows you to enter only that data in a cell that satisfies the criteria.
Detailed explanation-3: -Expert-Verified Answer Data validation works for setting a reasonable range for Inputs, as formula’s will apply on input values only, but for data validation the input values should be under a given range.
There is 1 question to complete.