Multiple Choice
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
Correct Answer:
Verified
Q2: All of the following statements are TRUE
Q3: To include a cell in the Watch
Q4: The Excel text-to-_ feature enables manual validation
Q5: An Excel _ reference describes a single
Q6: Actual cells that _ macro references will
Q8: _ macro references affect exactly the same
Q9: Running a macro in Excel deletes the
Q10: The _ appears when a user makes
Q11: When you record a macro,Excel is actually
Q12: _ validation allows you to specify more