DATABASE FUNDAMENTALS
USING DATA VALIDATION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Why is data validation used for?
|
|
(A) to control the type of data entered
|
|
|
(B) to ensure data entered meets requirements
|
|
|
Both (A) & (B)
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -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.
Detailed explanation-2: -Use data validation to restrict the type of data or the values that users enter into a cell. One of the most common data validation uses is to create a drop-down list.
Detailed explanation-3: -Data validation is a feature in Excel which is used to control what users can enter into a cell. It allows you to dictate specific rules. It also allows users to display a custom message if users try to enter invalid data.
There is 1 question to complete.