Exam 77-427 Microsoft Excel 2013 EXPERT 3. Create Advanced Formulas 3.2 Look Up Data with Functions: Data Validation (Settings)

Test the Settings 4. Try it: Enter an invalid number Go to Cell B2. Type: 12 Click Tab or Enter to leave the cell.   What Do You See? Well, it's a Microsoft error message that's completely accurate but not exactly clear.   There are three error options: Retry: Leaves the wrong number in Cell B2. Cancel: Clears the wrong number in Cell B2. Help: Opens a Help article.   Say this is the first time you saw this error message. How would you know what each button meant? Keep that in mind.   Click CANCEL. Cell B2 should be empty. Try This, Too: Rename the Sheet Double-click the tab. Rename the sheet: Timesheet.   So far, so good. Let's investigate a different validation criteria, please. Data ->Data Tools-> Data Validation