USING MICROSOFT EXCEL
USING DATA VALIDATION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
yes
|
|
|
no and yes
|
|
|
NO! Reasonable, not correct
|
|
|
yes! logical and correct
|
Detailed explanation-1: -You can use data validation to restrict the type of data or values that users enter into cells. For example, you might use data validation to calculate the maximum allowed value in a cell based on a value elsewhere in the workbook.
Detailed explanation-2: -When you validate, you make sure the data matches what you expect. A reasonableness check would ensure that data meets the expected range, type, or value. It is a common-sense check that you can use to ensure that your data is what is expected. Of course, you must have a solid grasp of what you expect the data to be!
Detailed explanation-3: -Degree of Accuracy It is still possible to enter data that meets the validation rules but is wrong. Verification methods also cannot make sure that the data entered is correct, they can make sure that is the same as what was written down but can give no certainty or accuracy.
Detailed explanation-4: -Why Validate? Validating the accuracy, clarity, and details of data is necessary to mitigate any project defects. Without validating data, you run the risk of basing decisions on data with imperfections that are not accurately representative of the situation at hand.