graphic2
graphic1

Exam 77-427 Microsoft Excel 2013 EXPERT
3. Create Advanced Formulas
3.2 Look Up Data with Functions: Data Validation (Settings)

pic1

Data Validation: Settings

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

 

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

 

Keep going...

Data ->Data Tools-> Data Validation