Back to lesson
1. How do you ensure that only dates, in a valid format, can be entered in a particular cell?
Create a data validation rule for the cell that restricts users to only entering dates.
Put a message in the cell that says users need to enter a valid date.
Set up a data validation input message for the cell.
2. Suppose you want a message to pop up each time a particular cell is selected. How do you make this happen?
Use a data validation input message.
Use a comment.
Use conditional formatting.
3. What is the most likely cause of this error message: “The value you entered is not valid. A user has restricted the values that can be entered into this cell”?
A validation rule was configured, and the rule's author programmed the error message text to read as in the message.
The user attempted to enter data into a protected worksheet.
A validation rule exists on the cell, but the rule's author didn't configure an error message.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement