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 collecting pictures to use with the VLOOKUP for pictures technique, what is the most important thing to remember about the pictures?
The picture (including its borders) must fit entirely within the cell
The pictures should all be the same size
The pictures must all be the same color
Don’t know
2
Advanced
When collecting pictures to use with the VLOOKUP for pictures technique, what is the easiest way to name each of the cells with a picture using the name on its left side?
Select A2:B5, go to Formulas Create from Selection Left column
Select B2, type Tents in the name box, and then repeat for the other 3 items
Go to the Formula Name Manager and create each name individually
Don’t know
3
Advanced
Naming cell E2 Products via the name box will create a named range formula of =Sheet1!$E$2. What needs to be done in order to make this dynamic so that you can link a picture to it?
The formula needs to be changed via the Name Manager to =SUBSTITUTE(Sheet1!$E$2," ","_")
The formula needs to be changed via the Name Manager to =INDIRECT(SUBSTITUTE(Sheet1!$E$2," ","_"))
The formula needs to be changed via the Name Manager to =INDIRECT(Sheet1!$E$2)
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement