Exam 77-427 Microsoft Excel 2013 EXPERT 3. Create Advanced Formulas 3.2 Look Up Data with Functions: Data Validation (Drop Down List-Error Alert)

Data Validation: Error Alert The Error Alert prompts people to fill in the right data. The Error Alert has a Title, Error message and a Style.   5. Try it: Edit the Error Alert Go to the Error Alert Tab. Select the Style: Information Title: Click CANCEL and try again Error Message: Select a client from the list.   Click OK and keep going...     Memo to Self: There are three Styles of Error Alerts: Stop, Warning, or Information. Each one has a different symbol and a different sound. Something as simple as picking a name from a list is Information, not a Critical Stop with every bell and whistle firing....really. The Computer Mama has a theory that the more you help your users, instead of scaring the wits out of them, the more they will be inclined to use your forms. Data ->Data Tools-> Data Validation