Web =IMPORTTEXT(path, [delimiter], [skip_rows], [take_rows], [encoding], [locale])

Quiz =IMPORTTEXT — 10 Questions

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

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

← IMPORTTEXT ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

What is the type of argument “locale” in =IMPORTTEXT?

Question 2 of 10 2/10

In =IMPORTTEXT, which is argument #3?

Question 3 of 10 3/10

What is the type of argument “delimiter” in =IMPORTTEXT?

Question 4 of 10 4/10

What is the type of argument “skip_rows” in =IMPORTTEXT?

Question 5 of 10 5/10

Does =IMPORTTEXT return a dynamic array?

Question 6 of 10 6/10

Which function is NOT related to =IMPORTTEXT?

Question 7 of 10 7/10

What is the output type of =IMPORTTEXT?

Question 8 of 10 8/10

Which category does =IMPORTTEXT belong to?

Question 9 of 10 9/10

Is argument “delimiter” required in =IMPORTTEXT?

Question 10 of 10 10/10

Which formula is a valid example of =IMPORTTEXT?

Click a question to see the answer.

1. What is the type of argument “locale” in =IMPORTTEXT?

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

Explanation: Type of “locale” is “Date”.

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

A. value
B. skip_rows ✓
C. criteria
D. locale

Explanation: Argument #3 is “skip_rows”.

3. What is the type of argument “delimiter” in =IMPORTTEXT?

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

Explanation: Type of “delimiter” is “Text”.

4. What is the type of argument “skip_rows” in =IMPORTTEXT?

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

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

5. Does =IMPORTTEXT return a dynamic array?

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

Explanation: IMPORTTEXT spills as a dynamic array.

6. Which function is NOT related to =IMPORTTEXT?

A. SCAN ✓
B. FILTERXML
C. COPILOT
D. ENCODEURL

Explanation: “SCAN” is not related to IMPORTTEXT.

7. What is the output type of =IMPORTTEXT?

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

Explanation: Output is “Text”.

8. Which category does =IMPORTTEXT belong to?

A. Logical
B. Compatibility
C. Web ✓
D. Date & Time

Explanation: Category is “Web”.

9. Is argument “delimiter” required in =IMPORTTEXT?

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

Explanation: “delimiter” is required.

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

A. IMPORTTEXT("C:\Data\example.txt",,,2)
B. =IMPORTTEXT("C:\Data\example.txt",,,2) ✓
C. =IMPORTTEXT("C:\Data\example.txt",,,2, 0)
D. =COPILOT("C:\Data\example.txt",,,2)

Explanation: Correct example: =IMPORTTEXT("C:\Data\example.txt",,,2)