Validating input data in flash
The best thing about using a table is that as you add or remove items from your list, your data validation list will update automatically.Note: The following examples use the Custom option where you write formulas to set your conditions.Pricing does not reflect any promotional offers or reduced pricing for Microsoft Imagine Academy program members, Microsoft Certified Trainers, and Microsoft Partner Network program members. Effective May 1, 2017, the existing cancellation policy will be replaced in its entirety with the following policy: Cancelling or rescheduling your exam within 5 business days of your registered exam time is subject to a fee. Please confirm exact pricing with the exam provider before registering to take an exam.The new Second Edition, now authored by Microsoft MVP and best-selling author Rob Miles, reflects all updated exam topics released by Microsoft through mid-2017.
Microsoft does not identify the format in which exams are presented.
For information on exam policies and scoring, see the Microsoft Certification exam policies and FAQs.
This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft.
Please use this preparation guide to prepare for the exam, regardless of its format.
To help you prepare for this exam, Microsoft recommends that you have hands-on experience with the product and that you use the specified training resources.
Search for validating input data in flash:
You can use data validation to restrict the type of data or the values that users enter into a cell.