Toggle navigation
GoSkills
Courses
Courses
Train your organization
Supercharge your organization with expert-led business and productivity courses.
Learn more
Learn on your own
Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses.
Learn more
Explore our courses
Browse our award-winning library of 110+ business and productivity courses delivered in bite-sized lessons.
Explore courses
LMS
Course builder
Resources
Pricing
Organization pricing
Individual pricing
Pricing
Search
Sign up
Log in
Log in
Signup
Quiz
1
Intermediate
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
Don’t know
2
Intermediate
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
Don’t know
3
Intermediate
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 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.
The user attempted to enter data into a protected worksheet.
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement