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

Data Validation: Settings Pick a Number from 1 to 10 Here is an example that allows a Whole Number between 0 and 11.   3. Try it: Enter the Validation criteria Allow: Whole Number Data: between Minimum: 0 (that's a zero) Maximum: 11   Click OK and keep going... Data ->Data Tools-> Data Validation