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
Advanced
When creating a Data Validation list, you are able to provide a list of items without linking to cells. What character is used to separate the individual items?
; (semi-colon)
. (period)
, (comma)
Don’t know
2
Advanced
When you want to use the values in the column of a table to drive a Data Validation list, it’s a good idea to provide a name for those cells. What is the fastest way to do this?
Select all the cells in the data range of the table’s column, go to Formulas ⇒ Name Manager, and create a new name
Select all the cells in the data range of the table’s column and type a new name in the name box
Select the cells, right click them and choose Insert ⇒ Name
Don’t know
3
Advanced
The workbook designer set up a Data Validation message with a custom error alert as shown in the image below. Which type of message style did they use to prevent you from putting in invalid data?
The Information style
The Stop style
The Warning style
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement