USING MICROSOFT EXCEL
USING DATA VALIDATION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following data validation settings can be set for a cell range?
|
|
Data Settings
|
|
|
Input Message
|
|
|
Error Message
|
|
|
All of the Above
|
Explanation:
Detailed explanation-1: -Data validation is a feature in Excel used to control what a user can enter into a cell. For example, you could use data validation to make sure a value is a number between 1 and 6, make sure a date occurs in the next 30 days, or make sure a text entry is less than 25 characters.
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.
There is 1 question to complete.