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 do you ensure that only dates, in a valid format, can be entered in a particular cell?
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
Create a data validation rule for the cell that restricts users to only entering dates
Don’t know
2
Intermediate
Suppose you want a message to pop up each time a particular cell is selected. How do you make this happen?
Use a comment
Use a data validation input message
Use conditional formatting
Don’t know
3
Intermediate
What is the most likely cause of this error message shown here?
A validation rule exists on the cell, but the rule's author didn't configure an error message
The user attempted to enter data into a protected worksheet.
A validation rule was configured, and the rule's author programmed the error message text to read as in the message
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement