Docstoc

data validation examples.xlsx

Document Sample
data validation examples.xlsx Powered By Docstoc
					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

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:5
posted:12/29/2011
language:
pages:7