Back to lesson
1. Which is the easiest method to assign a name to a cell or range of cells?
Go to the Formulas tab, click Name Manager and click New.
Select the cells, press Alt + N and type in the new name.
Select the cell(s) and then type the name in the Name Box (under the formula bar).
2. Suppose cell D32 is named “Target” and B23 contains the formula =D6*Target. What happens when B23 is copied to C24?
The new formula is =E7*OFFSET(Target,-1,-1).
The new formula remains as =D6*Target.
The new formula is =E7*Target.
3. Suppose cells B5:C50 are selected and named “tblData”, and B3 is named “lookup”. The formula =VLOOKUP(lookup,tblData,2,False) is created in E5. If E5 is copied to E6, what is the formula in E6?
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement