What is the easiest way to assign a name to a cell or range of cells?

Answer 1

Go to the Formulas tab, click Define Name, and click +

Answer 2

Select the cells, press Alt + N, then type in the new name

Answer 3

Select the cell(s), then type the name in the Name Box (under the formula bar)

Answer 4

Don’t know

Answer 5

The formula will still read =D6*Target

Answer 6

The new formula will read =E7*Target

Answer 7

The new formula will read =E7*OFFSET(Target,-1,-1)

Answer 8

Don’t know

Answer 9

=VLOOKUP(B3,B5:C50,2,False)

Answer 10

=VLOOKUP($B$3,$B$5:$C$50,2,False)

Answer 11

=VLOOKUP(lookup,tblData,2,False)

Answer 12

Don’t know

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?