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
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.