Create data validation rules in a spreadsheet to perform each of the following controls:
a. Limit check – that values in the cell are < 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 cell accepts no more than 40 characters of text
f. Reasonableness check – that cell’s value is less than 75% of cell to its left
g. Validity check – that a value exists in a list of allowable values