Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

data validation examples.xlsx

VIEWS: 5 PAGES: 7

									Excel       Data Validation
Microsoft   Accept only text entries
100   Data Validation
132   Accept value only if it is larger than the previous cell
155
1   Data Validation
2   Accepts only non-duplicated data
4
5
Alpha   Data Validation
apple   Accept entry only if it begins with A
Amos
Alpha   Data Validation
apple   Accept entry only if it begins with A and contains five characters
Aaron
Monday, March 13, 2006   Data Validation
Monday, June 18, 2007    Accept date entry only if it is a Monday.
Meat:          $120   Data Validation
Vegetables:     $30   Accept a value only if it doesn't go over the budget.
Fruit:          $50
Snacks:         $40
Alcohol:       $200   Party Budget:              $500
Soft Drinks:    $50   Total:                     $490

								
To top