Quiz

  1. 1
    Intermediate

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

  2. 2
    Intermediate

    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?

  3. 3
    Intermediate

    Assume we select cells B5:C50 and name it “tblData”, and also name B3 as “lookup”. Next we create a formula in E5 that reads: =VLOOKUP(lookup,tblData,2,False). When E5 is copied to E6, what will the formula in E6 show?