DATABASE FUNDAMENTALS
USING DATA VALIDATION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Settings, Input Message, Error Alert
|
|
|
Dates & Times, Numbers and Text
|
|
|
Data, Data Criteria, Data Validation
|
|
|
Rows, Cells and Columns
|
Detailed explanation-1: -Select the cell you want to validate. Go to the Data tab > Data tools, and click on the Data Validation button. A data validation dialogue box will appear having 3 tabs-Settings, Input Message, and Error Alerts.
Detailed explanation-2: -Using Data Validation Dialog Box to Define Validation Rules. The Data Validation dialogue box contains three essential options/ tabs: Settings, Input Message, and Error Alert.
Detailed explanation-3: -Whole Number-to restrict the cell to accept only whole numbers. Decimal-to restrict the cell to accept only decimal numbers. List-to pick data from the drop-down list. Date-to restrict the cell to accept only date.
Detailed explanation-4: -As you already know, the validation criteria are defined on the Settings tab of the Data Validation dialog box (Data tab > Data Validation).