Data Validation: Settings

2. What Do You See? Data Validation has three tabs: Settings, Input Message and Error Alert.

 

What Else Do You See? By default, Microsoft Excel accepts Any value: you can enter an equation or type the words to Good Night, Moon.

 

Keep going...

Exam 77-888: Microsoft Excel Expert 2010

2. Applying Formulas and Functions

2.4. Apply functions in formulas: Data Validation Settings

Data ->Data Tools-> Data Validation