All of the following statements are TRUE about data validation EXCEPT:
A)An Error Message appears when a user makes a validated cell active and prompts a user before data is entered with information about data constraints.
B)Each of the validation criteria can be specified with an Input Message and/or an Error Alert.
C)Data validation restricts a single validation criteria per cell.
D)Custom validation can be used to apply multiple validation criteria to a cell, but the formulas required tend to be much more complex.

Question

Quizplus · Accepted Answer

The Answer of All of the following statements are TRUE about data validation EXCEPT:
A)An Error Message appears when a user makes a validated cell active and prompts a user before data is entered with information about data constraints.
B)Each of the validation criteria can be specified with an Input Message and/or an Error Alert.
C)Data validation restricts a single validation criteria per cell.
D)Custom validation can be used to apply multiple validation criteria to a cell, but the formulas required tend to be much more complex.

All of the Following Statements Are TRUE About Data Validation