Text =MID(text, start_num, num_chars)

Quiz =MID — 10 Questions

10 quiz questions about =MID — test syntax, arguments, examples & errors!

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

← MID ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

What is the output type of =MID?

Question 2 of 10 2/10

How many arguments does =MID have in total?

Question 3 of 10 3/10

In =MID, which is argument #2?

Question 4 of 10 4/10

What is the type of argument “start_num” in =MID?

Question 5 of 10 5/10

Is argument “text” required in =MID?

Question 6 of 10 6/10

In =MID, which is argument #1?

Question 7 of 10 7/10

Which formula is a valid example of =MID?

Question 8 of 10 8/10

Which statement about =MID is correct?

Question 9 of 10 9/10

How many optional arguments does =MID have?

Question 10 of 10 10/10

What usually causes #VALUE! in =MID?

Click a question to see the answer.

1. What is the output type of =MID?

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

Explanation: Output is “Text”.

2. How many arguments does =MID have in total?

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

Explanation: =MID has 3 required, 0 optional (3 total).

3. In =MID, which is argument #2?

A. criteria
B. range
C. start_num ✓
D. text

Explanation: Argument #2 is “start_num”.

4. What is the type of argument “start_num” in =MID?

A. Number
B. Logical
C. Date
D. Any type ✓

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

5. Is argument “text” required in =MID?

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

Explanation: “text” is required.

6. In =MID, which is argument #1?

A. text ✓
B. num_chars
C. start_num
D. lookup_value

Explanation: Argument #1 is “text”.

7. Which formula is a valid example of =MID?

A. =FIND(A2,1,5)
B. MID(A2,1,5)
C. =MID(A2,1,5, 0)
D. =MID(A2,1,5) ✓

Explanation: Correct example: =MID(A2,1,5)

8. Which statement about =MID is correct?

A. Output is always a dynamic array
B. The MIDB function is deprecated. In workbooks set to Compatibility Version 2, MID has improved behavior with Surrogate Pairs, counting them as one character instead of two. Variation Selectors (commonly used with emojis) will still be counted as separate characters. Read more here: The Unicode standard ✓
C. Select entire column for best performance
D. Volatile and recalculates every time

Explanation: Correct: The MIDB function is deprecated. In workbooks set to Compatibility Version 2, MID has improved behavior with Surrogate Pairs, counting them as one character instead of two. Variation Selectors (commonly used with emojis) will still be counted as separate characters. Read more here: The Unicode standard

9. How many optional arguments does =MID have?

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

Explanation: =MID has 3 required, 0 optional (3 total).

10. What usually causes #VALUE! in =MID?

A. Select entire column for best performance
B. Only works in old versions
C. Requires add-in
D. If start_num is less than 1, MID returns the #VALUE! error value. If num_chars is negative, MID returns the #VALUE! error value. ✓

Explanation: If start_num is less than 1, MID returns the #VALUE! error value. If num_chars is negative, MID returns the #VALUE! error value. — Fix: Check the second and third arguments