Excel Problem

Create data validation rules in a spreadsheet to perform each of the following controls:

a. Limit check - that values in the cell are less than 70

b. Range check - that values in the cell are between 15 and 65

c. Sign check - that values in the cell are positive

d. Field check - that values in a cell are only numeric

e. Size check - that the cell accepts no more than 40 characters of text

f. Reasonableness check - that the cell's value is less than 75% of the cell to its left

g. Validity check - that a value exists in a list of allowable values