All of the following statements are TRUE regarding custom data validation EXCEPT:
A) Custom validation allows you to specify more complex criteria than allowed with the other validation types.
B) Data validation is an excellent tool to use in workbooks where you want to restrict data entry to certain values or ranges of values.
C) There may be times when data validation rules can hinder data entry rather than enhance it.
D) Using custom validation, you can apply multiple criteria one at a time.
Answer: D
You might also like to view...
An object of type ________ is used to manage the data flow between the program and the database.
a. EntityManager b. EntityManagerFactory c. Persistence d. TypedQuery
You can place a PivotTable in any ____________________ of any workbook.
Fill in the blank(s) with the appropriate word(s).
Write an If...Then...Else statement that assigns the number 2000 to theintBonusvariable when thedecSalesvariable contains a number that is greater than or equal to $50,000; otherwise, assign the number 500.
What will be an ideal response?
Case WDX 4-1Darwin works in the admissions department of a large university. He is creating a form letter to send to scholarship recipients. Darwin needs to make a few changes to the recipients' addresses. Which command will open the list for editing?
A. Edit Recipient List B. Edit Individual letters C. Start Mail Merge D. Type New List