Back to lesson
1. 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
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*OFFSET(Target,-1,-1)
The new formula will read =E7*Target
The formula will still read =D6*Target
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?
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement