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