Quiz

  1. 1
    Beginner

    Which of the following is the correct syntax for the OFFSET function?

  2. 2
    Beginner

    In the example, what would =SUM(OFFSET(B4,C4,D4,C4,C4)) return?

  3. 3
    Beginner

    To transpose using the OFFSET function, which other Excel function would you use in conjunction to show horizontal data vertically?