Lookup & Reference =MATCH(lookup_value, lookup_array, [match_type])

Quiz =MATCH — 15 Questions

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

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

← MATCH ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Is argument “lookup_value” required in =MATCH?

Question 2 of 15 2/15

Which category does =MATCH belong to?

Question 3 of 15 3/15

How many required arguments does =MATCH have?

Question 4 of 15 4/15

Which statement about =MATCH is correct?

Question 5 of 15 5/15

What is the output type of =MATCH?

Question 6 of 15 6/15

Is =MATCH volatile?

Question 7 of 15 7/15

Which function is related to =MATCH?

Question 8 of 15 8/15

What is the type of argument “lookup_value” in =MATCH?

Question 9 of 15 9/15

How many arguments does =MATCH have in total?

Question 10 of 15 10/15

What is the type of argument “lookup_array” in =MATCH?

Question 11 of 15 11/15

In =MATCH, which is argument #3?

Question 12 of 15 12/15

Is argument “match_type” required in =MATCH?

Question 13 of 15 13/15

In =MATCH, which is argument #2?

Question 14 of 15 14/15

Which function is NOT related to =MATCH?

Question 15 of 15 15/15

Which use case fits =MATCH?

Click a question to see the answer.

1. Is argument “lookup_value” required in =MATCH?

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

Explanation: “lookup_value” is required.

2. Which category does =MATCH belong to?

A. Date & Time
B. Logical
C. Compatibility
D. Lookup & Reference ✓

Explanation: Category is “Lookup & Reference”.

3. How many required arguments does =MATCH have?

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

Explanation: =MATCH has 2 required, 1 optional (3 total).

4. Which statement about =MATCH is correct?

A. Text is always ignored
B. Try using the new XMATCH function, an improved version of MATCH that works in any direction and returns exact matches by default, making it easier and more convenient to use than its predecessor. ✓
C. Use MATCH instead of one of the LOOKUP functions when you need the position of an item in a range instead of the item itself. For example, you might use the MATCH function to provide a value for the row_num argument of the INDEX function.
D. Requires add-in

Explanation: Correct: Try using the new XMATCH function, an improved version of MATCH that works in any direction and returns exact matches by default, making it easier and more convenient to use than its predecessor.

5. What is the output type of =MATCH?

A. Reference
B. Number ✓
C. Date
D. Mixed

Explanation: Output is “Number”.

6. Is =MATCH volatile?

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

Explanation: MATCH is not volatile.

7. Which function is related to =MATCH?

A. FLOOR.PRECISE
B. ODD
C. COLUMNS
D. INDEX ✓

Explanation: “INDEX” is related to MATCH.

8. What is the type of argument “lookup_value” in =MATCH?

A. Number
B. Any type ✓
C. Text
D. Value

Explanation: Type of “lookup_value” is “Any type”.

9. How many arguments does =MATCH have in total?

A. 2
B. 4
C. 5
D. 3 ✓

Explanation: =MATCH has 2 required, 1 optional (3 total).

10. What is the type of argument “lookup_array” in =MATCH?

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

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

11. In =MATCH, which is argument #3?

A. lookup_array
B. match_type ✓
C. range
D. lookup_value

Explanation: Argument #3 is “match_type”.

12. Is argument “match_type” required in =MATCH?

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

Explanation: “match_type” is optional.

13. In =MATCH, which is argument #2?

A. criteria
B. lookup_array ✓
C. value
D. match_type

Explanation: Argument #2 is “lookup_array”.

14. Which function is NOT related to =MATCH?

A. INDEX
B. PHI ✓
C. XLOOKUP
D. VLOOKUP

Explanation: “PHI” is not related to MATCH.

15. Which use case fits =MATCH?

A. Error Handling
B. Investment Appraisal
C. Daily Tasks ✓
D. Data Cleaning

Explanation: Use case “Daily Tasks” fits MATCH.