Back to lesson
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 +
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
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
© 2018 GoSkills Ltd.
Skills for career advancement