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
What is the easiest way to assign a name to a cell or range of cells?
Select the cell(s), then type the name in the Name Box (under the formula bar)
Go to the Formulas tab, click Define Name, and click +
Select the cells, press Alt + N, then type in the new name
Don’t know
2
Intermediate
Assume that we give cell D32 a name of “Target”, and we set up a formula in B23 that reads =D6*Target. What will happen when we copy B23 to C24?
The formula will still read =D6*Target
The new formula will read =E7*OFFSET(Target,-1,-1)
The new formula will read =E7*Target
Don’t know
3
Intermediate
Assume we select cells B5:C50 and name it “tblData”, and also name B3 as “lookup”. Next we create a formula in E5 that reads: =VLOOKUP(lookup,tblData,2,False). When E5 is copied to E6, what will the formula in E6 show?
=VLOOKUP($B$3,$B$5:$C$50,2,False)
=VLOOKUP(lookup,tblData,2,False)
=VLOOKUP(B3,B5:C50,2,False)
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement