Search for courses or lessons
Redeem a coupon
Start free trial
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 (to the left of the formula bar)
Go to the Formulas tab, click Name Manager and click New
Select the cells, press Alt + N and type in the new name
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*Target
The new formula remains as =D6*Target
The new formula is =E7*OFFSET(Target,-1,-1)
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
© 2020 GoSkills Ltd.
Skills for career advancement