Short Answer
Match the following terms to their description.
I.Data validation
II.List validation
III.Decimal validation
IV.Date validation
V.Whole number validation
A.Restricts users to entering data in a cell that contain digits and a decimal point
B.Any means of increasing the probability of correct data entry through programmatic tools and/or behavioral modifications
C.Restricts the user to entering integer values in a validated cell
D.Presents the user with a list of data values from which the user can choose
E.Restricts the user to entering dates that satisfy the specified criteria in a validated cell
Correct Answer:

Verified
Correct Answer:
Verified
Q49: Named ranges that are to be used
Q50: To select all cells that contain a
Q51: Excel protection features can be found in
Q52: Using named ranges to identify source data
Q53: The actual cells that _ macro references
Q55: The _ feature of Excel can be
Q56: Whole number validation is functionally identical to
Q57: A(n)_ appears when a user makes a
Q58: To select all cells that contain a
Q59: _ length validation can be very important