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: Errors What happens if you type a name that is NOT on the list...as many users do?   7. Try it: Type the Wrong Name Go to Cell A2. Type: Lansing. Click TAB on your keyboard to go to B2.   What Do You See? If the data does not match--hence it isn't valid--then you will be prompted with your Error Alert.   What Did You Hear? Did you hear a little chime when you tabbed out of Cell A2?   What Are the Options? If you click OK you will return to Cell A2, but selecting OK leaves the wrong name there. If you click CANCEL then you will return to Cell A2 and it will be empty.   Click CANCEL, please. Data ->Data Tools-> Data Validation