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

Quiz =IMPORTTEXT — 15 Questions

15 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 — 15 questions 1 of 15

Question 1 of 15 1/15

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

Question 2 of 15 2/15

What is the output type of =IMPORTTEXT?

Question 3 of 15 3/15

How many required arguments does =IMPORTTEXT have?

Question 4 of 15 4/15

Is argument “encoding” required in =IMPORTTEXT?

Question 5 of 15 5/15

In =IMPORTTEXT, which is argument #1?

Question 6 of 15 6/15

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

Question 7 of 15 7/15

Which use case fits =IMPORTTEXT?

Question 8 of 15 8/15

How many optional arguments does =IMPORTTEXT have?

Question 9 of 15 9/15

Since which Excel version is =IMPORTTEXT available?

Question 10 of 15 10/15

Is argument “take_rows” required in =IMPORTTEXT?

Question 11 of 15 11/15

Is argument “path” required in =IMPORTTEXT?

Question 12 of 15 12/15

In =IMPORTTEXT, which is argument #2?

Question 13 of 15 13/15

Does =IMPORTTEXT return a dynamic array?

Question 14 of 15 14/15

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

Question 15 of 15 15/15

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

Click a question to see the answer.

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

A. Reference
B. Range
C. Text
D. Date ✓

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

2. What is the output type of =IMPORTTEXT?

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

Explanation: Output is “Text”.

3. How many required arguments does =IMPORTTEXT have?

A. 6 ✓
B. 5
C. 8
D. 7

Explanation: =IMPORTTEXT has 6 required, 0 optional (6 total).

4. Is argument “encoding” required in =IMPORTTEXT?

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

Explanation: “encoding” is required.

5. In =IMPORTTEXT, which is argument #1?

A. range
B. locale
C. delimiter
D. path ✓

Explanation: Argument #1 is “path”.

6. What is the type of argument “take_rows” in =IMPORTTEXT?

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

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

7. Which use case fits =IMPORTTEXT?

A. Numbering & Sample Data
B. Ranking & Top N
C. Rounding & Numeric
D. External Data, Web & Cube ✓

Explanation: Use case “External Data, Web & Cube” fits IMPORTTEXT.

8. How many optional arguments does =IMPORTTEXT have?

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

Explanation: =IMPORTTEXT has 6 required, 0 optional (6 total).

9. Since which Excel version is =IMPORTTEXT available?

A. Excel 365
B. All versions
C. Microsoft 365 ✓
D. Excel 2019

Explanation: Version: “Microsoft 365”.

10. Is argument “take_rows” required in =IMPORTTEXT?

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

Explanation: “take_rows” is required.

11. Is argument “path” required in =IMPORTTEXT?

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

Explanation: “path” is required.

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

A. take_rows
B. path
C. encoding
D. delimiter ✓

Explanation: Argument #2 is “delimiter”.

13. Does =IMPORTTEXT return a dynamic array?

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

Explanation: IMPORTTEXT spills as a dynamic array.

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

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

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

15. What is the type of argument “encoding” in =IMPORTTEXT?

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

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