GoSkills
Back to lesson
Question
1
of
3
1. Which of the following is correct about the OFFSET function?
The function is about disposition. It returns the contents of a cell a specified number of rows down and a specified number of columns to the right of the base cell(s)
The function is about position. It returns the contents of a cell at the intersection of a specified row and column number in the array highlighted
The function is about disposition. It returns the contents of a cell a specified number of rows up and a specified number of columns to the left of the base cell(s)
Don’t know
2. In the example, what would =OFFSET(E6,2,-2) return?
26
6
30
Don’t know
3. If an OFFSET formula results in evaluating a non-existing cell (e.g. a cell to the left or above cell A1), what value would the function return?
#REF!
#NULL!
#VALUE!
Don’t know
Quiz progress
Previous
question
Next
question
Submit
answers
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement