All of the following statements are TRUE regarding custom data validation EXCEPT:
A)Custom validation allows you to specify more complex criteria than allowed with the other validation types.
B)Data validation is an excellent tool to use in workbooks where you want to restrict data entry to certain values or ranges of values.
C)There may be times when data validation rules can hinder data entry rather than enhance it.
D)Using custom validation, you can apply multiple criteria one at a time.

Question

Quizplus · Accepted Answer

Using custom validation, you can apply multiple criteria at once, not one at a time. Therefore, option D is incorrect. However, options A, B, and C are all true statements about custom data validation.

All of the Following Statements Are TRUE Regarding Custom Data