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.
Correct Answer:
Verified
Correct Answer:
Verified
Q90: In cases where a codified data value
Q91: Active code such as macros and ActiveX
Q92: Which of the following is NOT an
Q93: The _ informs a user when entered
Q94: Generally,circular references are of no concern to
Q95: If you make a mistake when recording
Q96: Text length validation can be very important
Q97: _ validation allows users to apply multiple
Q98: _ uses a password to create a
Q99: The moment a(n)_ validation cell is made