Back to lesson
1. How would you force a user to only enter a valid date in cell C1?
Put a message in A1 that says they need to enter a valid date
Set up a data validation input message
Create a data validation rule that restricts users to entering dates
2. If you wanted to set up a message that pops up every time the user selects a specific cell, how would you do it?
Use a comment
Use conditional formatting
Use a data validation input message
3. What would be the most likely cause of the following error message appearing in Excel? “The value you entered is not valid. A user has restricted the values that can be entered into this cell.”
The user attempted to enter data into a protected worksheet.
A validation rule exists on the cell, but the author never configured an error message.
A validation rule was configured, and the author programmed the error message text to read as in the message.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement