|
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
Data ->Data Tools-> Data Validation
Exam 77-888: Microsoft Excel Expert
2010
2. Applying Formulas and Functions
2.4. Apply functions in formulas:
Data Validation Settings |
|
| |
