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 output type of =INDEX?

Question 2 of 15 2/15

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

Question 3 of 15 3/15

Which category does =INDEX belong to?

Question 4 of 15 4/15

Which function is related to =INDEX?

Question 5 of 15 5/15

What usually causes #REF! in =INDEX?

Question 6 of 15 6/15

Which formula is a valid example of =INDEX?

Question 7 of 15 7/15

Is argument “reference” required in =INDEX?

Question 8 of 15 8/15

In =INDEX, which is argument #2?

Question 9 of 15 9/15

What usually causes #VALUE! in =INDEX?

Question 10 of 15 10/15

Is argument “area_num” required in =INDEX?

Question 11 of 15 11/15

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

Question 12 of 15 12/15

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

Question 13 of 15 13/15

Which use case fits =INDEX?

Question 14 of 15 14/15

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

Question 15 of 15 15/15

Does =INDEX return a dynamic array?

Click a question to see the answer.

1. What is the output type of =INDEX?

A. Reference
B. Array
C. Mixed ✓
D. Value

Explanation: Output is “Mixed”.

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

A. Requires add-in
B. Check the numbers and the range size ✓
C. Volatile and recalculates every time
D. Select entire column for best performance

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

3. Which category does =INDEX belong to?

A. Text
B. Engineering
C. Lookup & Reference ✓
D. Information

Explanation: Category is “Lookup & Reference”.

4. Which function is related to =INDEX?

A. RANK.EQ
B. XIRR
C. DEC2HEX
D. MATCH ✓

Explanation: “MATCH” is related to INDEX.

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

A. Only works in old versions
B. ناحیه‌های reference در برگ‌های مختلف قرار دارند.
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. Text is always ignored

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

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

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

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

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

Explanation: “reference” is required.

8. In =INDEX, which is argument #2?

A. value
B. area_num
C. reference
D. row_num ✓

Explanation: Argument #2 is “row_num”.

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

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

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

10. Is argument “area_num” required in =INDEX?

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

Explanation: “area_num” is optional.

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

A. Text
B. Number ✓
C. Value
D. Array

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

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

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

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

13. Which use case fits =INDEX?

A. Conditional Formatting & Validation
B. Error Handling
C. Daily Tasks ✓
D. Ranking & Top N

Explanation: Use case “Daily Tasks” fits INDEX.

14. What is the type of argument “reference” in =INDEX?

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

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

15. Does =INDEX return a dynamic array?

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

Explanation: INDEX does not spill.