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

How many arguments does =MID have in total?

Question 2 of 10 2/10

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

Question 3 of 10 3/10

Is argument “start_num” required in =MID?

Question 4 of 10 4/10

Which use case fits =MID?

Question 5 of 10 5/10

Is argument “num_chars” required in =MID?

Question 6 of 10 6/10

In =MID, which is argument #3?

Question 7 of 10 7/10

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

Question 8 of 10 8/10

Which function is related to =MID?

Question 9 of 10 9/10

Which category does =MID belong to?

Question 10 of 10 10/10

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

Click a question to see the answer.

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

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

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

2. What is the fix for #VALUE! in =MID?

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

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

3. Is argument “start_num” required in =MID?

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

Explanation: “start_num” is required.

4. Which use case fits =MID?

A. Text Manipulation
B. Financial Calculations
C. Numbering & Sample Data
D. Daily Tasks ✓

Explanation: Use case “Daily Tasks” fits MID.

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

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

Explanation: “num_chars” is required.

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

A. start_num
B. value
C. num_chars ✓
D. criteria

Explanation: Argument #3 is “num_chars”.

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

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

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

8. Which function is related to =MID?

A. FIND ✓
B. CHOOSECOLS
C. TIMEVALUE
D. DURATION

Explanation: “FIND” is related to MID.

9. Which category does =MID belong to?

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

Explanation: Category is “Text”.

10. What is the type of argument “num_chars” in =MID?

A. Any type ✓
B. Mixed
C. Date
D. Reference

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