Back to lesson
1. Which is the easiest method to assign a name to a cell or range of cells?
Select the cell(s) and then type the name in the Name Box (under the formula bar).
Select the cells, press Alt + N and type in the new name.
Go to the Formulas tab, click Name Manager and click New.
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 remains as =D6*Target.
The new formula is =E7*Target.
The new formula is =E7*OFFSET(Target,-1,-1).
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
© 2018 GoSkills Ltd.
Skills for career advancement