Lookup & Reference
=OFFSET(reference, rows, cols, [height], [width])
Quiz =OFFSET — 10 Questions
10 quiz questions about =OFFSET — test syntax, arguments, examples & errors!
Questions:
10 questions
15 questions
Random 10 or 15 questions from the pool + shuffled options each time
Progress — 10 questions
1 of 10
Question 1 of 10
1/10
What is the type of argument “height” in =OFFSET?
Explanation: Type of “height” is “Number”.
Question 2 of 10
2/10
Which statement about =OFFSET is correct?
Explanation: Correct: If height or width is omitted, it is assumed to be the same height or width as reference.
Question 3 of 10
3/10
How many arguments does =OFFSET have in total?
Explanation: =OFFSET has 3 required, 2 optional (5 total).
Question 4 of 10
4/10
What usually causes #REF! in =OFFSET?
Explanation: If rows and cols offset reference over the edge of the worksheet, OFFSET returns the #REF! error value. — Fix: Check the offset numbers and the size of the range
Question 5 of 10
5/10
What is the type of argument “width” in =OFFSET?
Explanation: Type of “width” is “Number”.
Question 6 of 10
6/10
Is argument “reference” required in =OFFSET?
Explanation: “reference” is required.
Question 7 of 10
7/10
Is argument “cols” required in =OFFSET?
Explanation: “cols” is required.
Question 8 of 10
8/10
In =OFFSET, which is argument #2?
Explanation: Argument #2 is “rows”.
Question 9 of 10
9/10
What is the fix for #REF! in =OFFSET?
Explanation: If rows and cols offset reference over the edge of the worksheet, OFFSET returns the #REF! error value. — Fix: Check the offset numbers and the size of the range
Question 10 of 10
10/10
What is the type of argument “cols” in =OFFSET?
Explanation: Type of “cols” is “Number”.