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?
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
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 conditional formatting
Use a comment
Use a data validation input message
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.”
A validation rule was configured, and the author programmed the error message text to read as in the message.
A validation rule exists on the cell, but the author never configured an error message.
The user attempted to enter data into a protected worksheet.
Back to the top
© 2019 GoSkills Ltd.
Skills for career advancement