Lookup & Reference =INDEX(array, row_num, [column_num])

Quiz =INDEX — 15 Questions

15 quiz questions about =INDEX — test syntax, arguments, examples & errors!

Questions: 10 questions 15 questions Random 10 or 15 questions from the pool + shuffled options each time

← INDEX ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

What is the type of argument “column_num” in =INDEX?

Question 2 of 15 2/15

What usually causes #VALUE! in =INDEX?

Question 3 of 15 3/15

What is the type of argument “row_num” in =INDEX?

Question 4 of 15 4/15

How many optional arguments does =INDEX have?

Question 5 of 15 5/15

What is the type of argument “array” in =INDEX?

Question 6 of 15 6/15

Does =INDEX return a dynamic array?

Question 7 of 15 7/15

What is the fix for #VALUE! in =INDEX?

Question 8 of 15 8/15

Which function is NOT related to =INDEX?

Question 9 of 15 9/15

What usually causes #REF! in =INDEX?

Question 10 of 15 10/15

Which formula is a valid example of =INDEX?

Question 11 of 15 11/15

Which is the correct syntax of =INDEX?

Question 12 of 15 12/15

Is argument “reference” required in =INDEX?

Question 13 of 15 13/15

In =INDEX, which is argument #3?

Question 14 of 15 14/15

Which statement about =INDEX is correct?

Question 15 of 15 15/15

What is the fix for #REF! in =INDEX?

Click a question to see the answer.

1. What is the type of argument “column_num” in =INDEX?

A. Logical
B. Number ✓
C. Range
D. Value

Explanation: Type of “column_num” is “Number”.

2. What usually causes #VALUE! in =INDEX?

A. Requires add-in
B. If you specify areas that are not on the same sheet as each other, it will cause a #VALUE! error. ✓
C. Output is always a dynamic array
D. Volatile and recalculates every time

Explanation: If you specify areas that are not on the same sheet as each other, it will cause a #VALUE! error. — Fix: همه ناحیه‌ها را در یک برگ قرار دهید یا از شکل آرایه‌ای INDEX به همراه تابع CHOOSE برای ترکیب محدوده‌ها استفاده کنید.

3. What is the type of argument “row_num” in =INDEX?

A. Value
B. Number ✓
C. Mixed
D. Range

Explanation: Type of “row_num” is “Number”.

4. How many optional arguments does =INDEX have?

A. 0
B. 2
C. 3
D. 1 ✓

Explanation: =INDEX has 4 required, 1 optional (5 total).

5. What is the type of argument “array” in =INDEX?

A. Array
B. Reference
C. Text
D. Range ✓

Explanation: Type of “array” is “Range”.

6. Does =INDEX return a dynamic array?

A. No
B. Yes
C. No ✓
D. —

Explanation: INDEX does not spill.

7. What is the fix for #VALUE! in =INDEX?

A. Text is always ignored
B. Select entire column for best performance
C. همه ناحیه‌ها را در یک برگ قرار دهید یا از شکل آرایه‌ای INDEX به همراه تابع CHOOSE برای ترکیب محدوده‌ها استفاده کنید. ✓
D. Requires add-in

8. Which function is NOT related to =INDEX?

A. XMATCH
B. OFFSET
C. CUBEMEMBERPROPERTY ✓
D. MATCH

Explanation: “CUBEMEMBERPROPERTY” is not related to INDEX.

9. What usually causes #REF! in =INDEX?

A. Select entire column for best performance
B. Text is always ignored
C. row_num and column_num must point to a cell within array; otherwise, INDEX returns a #REF! error. row_num, column_num, and area_num must point to a cell within reference; otherwise, INDEX returns a #REF! error. ✓
D. Requires add-in

Explanation: row_num and column_num must point to a cell within array; otherwise, INDEX returns a #REF! error. row_num, column_num, and area_num must point to a cell within reference; otherwise, INDEX returns a #REF! error. — Fix: Check the numbers and the range size

10. Which formula is a valid example of =INDEX?

A. INDEX(A2:B3,2,2)
B. =MATCH(A2:B3,2,2)
C. =INDEX(A2:B3,2,2) ✓
D. =INDEX(A2:B3,2,2, 0)

Explanation: Correct example: =INDEX(A2:B3,2,2)

11. Which is the correct syntax of =INDEX?

A. =MATCH(array, row_num, [column_num])
B. =INDEX(array, row_num, [column_num]) ✓
C. INDEX(array, row_num, [column_num])
D. =INDEX(array, row_num, [column_num], 0)

Explanation: Correct syntax: =INDEX(array, row_num, [column_num])

12. Is argument “reference” required in =INDEX?

A. Yes
B. —
C. No
D. Yes ✓

Explanation: “reference” is required.

13. In =INDEX, which is argument #3?

A. lookup_value
B. column_num ✓
C. row_num
D. value

Explanation: Argument #3 is “column_num”.

14. Which statement about =INDEX is correct?

A. After reference and area_num have selected a particular range, row_num and column_num select a particular cell: row_num 1 is the first row in the range, column_num 1 is the first column, and so on. The reference returned by INDEX is the intersection of row_num and column_num.
B. Output is always a dynamic array
C. If both the row_num and column_num arguments are used, INDEX returns the value in the cell at the intersection of row_num and column_num. ✓
D. Select entire column for best performance

Explanation: Correct: If both the row_num and column_num arguments are used, INDEX returns the value in the cell at the intersection of row_num and column_num.

15. What is the fix for #REF! in =INDEX?

A. Text is always ignored
B. Select entire column for best performance
C. Only works in old versions
D. Check the numbers and the range size ✓