Quiz

  1. 1
    Intermediate

    Which is the easiest method to assign a name to a cell or range of cells?

  2. 2
    Intermediate

    Suppose cell D32 is named “Target” and B23 contains the formula =D6*Target. What happens when B23 is copied to C24?

  3. 3
    Intermediate

    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?