DATABASE FUNDAMENTALS
USING DATA VALIDATION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Charts
|
|
|
Data
|
|
|
Formulas
|
|
|
Tables
|
Detailed explanation-1: -On the Data tab, in the Data Tools group, click Data Validation. On the Settings tab, in the Allow box, select List. In the Source box, type your list values, separated by commas.
Detailed explanation-2: -Data validation is a feature in Excel which is used to control what users can enter into a cell. It allows you to dictate specific rules. It also allows users to display a custom message if users try to enter invalid data.
Detailed explanation-3: -Select one or more cells to validate, go to the Data tab > Data Tools group, and click the Data Validation button.
Detailed explanation-4: -Step 2: Set the Data Validation Rule After the data validation dialogue box is displayed, we need to go to the Settings tab to define validation criteria. We can provide the desired values, cell references, or formulas in the validation criteria.