Question: Excel Problem Create data validation rules in a spreadsheet to perform each of the following controls: a. Limit checkthat values in the cell are less
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 the 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
