Question: 2 Using the Data Validation function, outline the steps that would apply the following data validation rule to the cell range B 8 to C
Using the Data Validation function, outline the steps that would apply the following data validation rule to the cell range to :
a Type of data shall not be in decimals and must be greater than or equal to
b The input message displayed should say "Please key in a number no less than
c The error alert displayed should say No numbers less than or in decimals!" Make sure you have tested the data validation rule.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
