FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

USING DATA VALIDATION IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following represent the three sections of Data Validation when you see the Data Validation dialogue box?
A
Settings, Input Message, Error Alert
B
Dates & Times, Numbers and Text
C
Data, Data Criteria, Data Validation
D
Rows, Cells and Columns
Explanation: 

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: -c) Data, Data Criteria, Data Validation

Detailed explanation-4: -In Excel, data validation is found on the “Data” ribbon, under “Data Validation.” Once clicked, the data validation window will pop up. It will show three tabs: Settings, Input Message, and Error Alert.

Detailed explanation-5: -Based on the Microsoft Excel data validation, the option that is not an Error Style for data validation is the choice that does not show an error alert.

There is 1 question to complete.
Previous
Next