|
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 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
Exam 77-888: Microsoft Excel Expert
2010
2. Applying Formulas and Functions
2.4. Apply functions in formulas:
Data Validation |
|
| |
