Toggle navigation
GoSkills
Search for courses or lessons
Courses
For Teams
For Teams
Teach
Blog
Redeem a coupon
Start free trial
Search
Login
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 new formula will read =E7*OFFSET(Target,-1,-1)
The formula will still read =D6*Target
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
© 2019 GoSkills Ltd.
Skills for career advancement