All of the Following Statements Are TRUE About Data Validation

question 100

Multiple Choice

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.