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
Q78: Tracing formulas draws _ from a formula
Q79: _ includes rules that determine what can
Q80: A(n)_ cell is a cell whose value
Q81: Completely hiding formulas in a worksheet is
Q82: Protecting the workbook _ stops users from
Q84: _ represents a means of communicating the
Q85: When you record a macro,Excel is actually
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
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