Search for courses or lessons
Redeem a coupon
Start free trial
How would you force a user to only enter a valid date in cell C1?
Create a data validation rule that restricts users to entering dates
Set up a data validation input message
Put a message in A1 that says they need to enter a valid date
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 data validation input message
Use a comment
Use conditional formatting
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
© 2019 GoSkills Ltd.
Skills for career advancement