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
Beginner
In our lesson, we use a helper column to create a composite lookup value using two pieces of text. Which symbol do we use to join the pieces of text together?
$
>
+
&
2
Beginner
In our lesson, we add a 'Helper' column to the front of our table to create a composite lookup value. This means we need to change one of our VLOOKUP arguments - which one?
table_array
lookup_value
col_index_num
range_lookup
3
Beginner
Which key do we press to change a cell reference from relative to absolute?
F1
F2
F3
F4
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement