GoSkills
Back to lesson
Question
1
of
3
1. What is the easiest way to assign a name to a cell or range of cells?
Select the cells, press Alt + N, then type in the new name
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 +
Don’t know
2. 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*Target
The new formula will read =E7*OFFSET(Target,-1,-1)
The formula will still read =D6*Target
Don’t know
3. 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(B3,B5:C50,2,False)
=VLOOKUP(lookup,tblData,2,False)
Don’t know
Quiz progress
Previous
question
Next
question
Submit
answers
Back to the top
© 2018 GoSkills Ltd.
Skills for career advancement