Question

Order the steps to successfully complete data validation.

Set Settings
Complete the Error Alert
Add Input Message
Click Data Tools in the
Data tab of the ribbon.
Select Data Validation.

Answer 1

1. Open the Data Validation dialog box Select one or more cells to validate, go to the Data tab > Data Tools group, and click the Data Validation button.

2. Create an Excel validation rule On the Settings tab, define the validation criteria according to your needs.

3. Add an input message (optional)

4. Display an error alert (optional)

Answer 2

Select data validation

Set settings

Add input message

Complete the error alert