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

2 Using the Data Validation function, outline the steps that would apply the following data validation rule to the cell range B8 to C14 :
(a) Type of data shall not be in decimals and must be greater than or equal to 0.
(b) The input message displayed should say "Please key in a number no less than 0.
(c) The error alert displayed should say "No numbers less than 0 or in decimals!" Make sure you have tested the data validation rule.
 2 Using the Data Validation function, outline the steps that would

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!