Back to lesson
1. Which of the following is the correct syntax for the OFFSET function?
=OFFSET(Reference, Columns, Rows, [Width], [Height])
=OFFSET(Reference, Rows, Columns)
=OFFSET(Reference, Rows, Columns, [Height], [Width])
2. In the example, what would =SUM(OFFSET(B4,C4,D4,C4,C4)) return?
3. To transpose using the OFFSET function, which other Excel function would you use in conjunction to show horizontal data vertically?
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement