Match the following terms to their description.
I.Boolean operator
II.Custom validation
III.Any value validation
IV.Text length validation
V.Codification schemes
A) Consists of rules that combine data values in specific formats and locations to generate a new data value
B) Generally used to limit the number of characters that can be entered into a cell
C) Allows users to specify more complex criteria and apply multiple criteria simultaneously
D) A means of using the Input Message available through the data validation tools to communicate data entry rules and/or expectations to the user
E) Tests the relationship between two values and returns TRUE or FALSE
Correct Answer:
Verified
Q86: The moment a(n)_ validation cell is made
Q87: A(n)_ is a form of computer program
Q88: _ uses a password to create a
Q89: Macros can be run from the _
Q90: The 40th room on floor 7 of
Q92: _ schemes are rules that combine data
Q93: The _ tab is used to hide
Q94: If a workbook in a(n)_ is opened,macros
Q95: _ are objects that when clicked with
Q96: The Excel text-to-_ feature enables manual validation
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents