Excel: Overtime (Page 1) 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38

Error Message

An error message needs to be more than beeps and buzzers. Practical people want to know how to do the job right. Use the Error options to teach someone how to correct the mistake.

 

There are three alert styles : Stop, Warning and Information. For example, the Stop message has an annoying sound and too many buttons.

 

Try it: Edit the Validation Error

What is the difference between Retry and Cancel? Which choice deletes the wrong answer?

 

Data ->Data Tools-> Data Validation

 

  Microsoft Excel 2007 Exam 77-602 Topic: 1. Creating and Manipulating Data

  1.2.1. Restrict data using data validation: Restrict the type of data that can be entered in cells